eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: SYS.MLOG$

Object Details

Object Name:	MLOG$
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	0
PCT Used:	0

Columns

Name	Datatype	Length	Mandatory
MOWNER	VARCHAR2	(128)	Yes
MASTER	VARCHAR2	(128)	Yes
OLDEST	DATE
OLDEST_PK	DATE
OLDEST_SEQ	DATE
OSCN	NUMBER
YOUNGEST	DATE
YSCN	NUMBER
LOG	VARCHAR2	(128)	Yes
TRIG	VARCHAR2	(128)
FLAG	NUMBER
MTIME	DATE		Yes
TEMP_LOG	VARCHAR2	(128)
OLDEST_OID	DATE
OLDEST_NEW	DATE
PURGE_START	DATE
PURGE_NEXT	VARCHAR2	(200)
PURGE_JOB	VARCHAR2	(128)
LAST_PURGE_DATE	DATE
LAST_PURGE_STATUS	NUMBER
ROWS_PURGED	NUMBER
OSCN_PK	NUMBER
OSCN_SEQ	NUMBER
OSCN_OID	NUMBER
OSCN_NEW	NUMBER
PARTDOBJ#	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MOWNER
,      MASTER
,      OLDEST
,      OLDEST_PK
,      OLDEST_SEQ
,      OSCN
,      YOUNGEST
,      YSCN
,      LOG
,      TRIG
,      FLAG
,      MTIME
,      TEMP_LOG
,      OLDEST_OID
,      OLDEST_NEW
,      PURGE_START
,      PURGE_NEXT
,      PURGE_JOB
,      LAST_PURGE_DATE
,      LAST_PURGE_STATUS
,      ROWS_PURGED
,      OSCN_PK
,      OSCN_SEQ
,      OSCN_OID
,      OSCN_NEW
,      PARTDOBJ#
FROM SYS.MLOG$;

Dependencies

[top of page]

SYS.MLOG$ does not reference any database object

SYS.MLOG$ is referenced by following:

SYS: DBA_MVIEW_LOGS; DBA_SNAPSHOT_LOGS; DBA_STREAMS_COLUMNS; DBMS_EXTENDED_TTS_CHECKS - show dependent code; DBMS_ISNAPSHOT - show dependent code; DBMS_OFFLINE_UTL - show dependent code; DBMS_REPCAT_MIG_INTERNAL - show dependent code; DBMS_SNAPSHOT - show dependent code; DBMS_SNAPSHOT_UTL - show dependent code; DBMS_SNAP_INTERNAL - show dependent code; DBMS_STATS_INTERNAL - show dependent code; EXU10SNAPL; EXU7DELSNAPL; EXU7SNAPL; EXU7SNAPLU; EXU8DELSNAPL; EXU9SNAPL; KU$_MVLPROP_VIEW; KU$_MV_DEPTBL_OBJNUM_VIEW; KU$_M_VIEW_LOG_VIEW; KU$_TTS_MVL_VIEW; LOGSTDBY_RU_UNSUPPORT_TAB_12_1; LOGSTDBY_SUPPORT_TAB_10_1; LOGSTDBY_SUPPORT_TAB_10_2; LOGSTDBY_SUPPORT_TAB_11_1; LOGSTDBY_SUPPORT_TAB_11_2; LOGSTDBY_SUPPORT_TAB_11_2B; LOGSTDBY_SUPPORT_TAB_12_1; LOGSTDBY_UNSUPPORT_TAB_10_1; LOGSTDBY_UNSUPPORT_TAB_10_2; LOGSTDBY_UNSUPPORT_TAB_11_1; LOGSTDBY_UNSUPPORT_TAB_11_2; LOGSTDBY_UNSUPPORT_TAB_11_2B; LOGSTDBY_UNSUPPORT_TAB_12_1; STRADDLING_RS_OBJECTS; _DBA_STREAMS_UNSUPPORTED_10_1; _DBA_STREAMS_UNSUPPORTED_10_2; _DBA_STREAMS_UNSUPPORTED_11_1; _DBA_STREAMS_UNSUPPORTED_11_2; _DBA_STREAMS_UNSUPPORTED_12_1; _DBA_STREAMS_UNSUPPORTED_9_2