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

VIEW: SYS.DBA_LOGMNR_LOG

Object Details
Object Name: DBA_LOGMNR_LOG
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOGMNR_SESSION_ID NUMBER
Yes
NAME VARCHAR2 (513)
DBID NUMBER
Yes
RESETLOGS_SCN NUMBER
Yes
RESETLOGS_TIME NUMBER
Yes
MODIFIED_TIME DATE

THREAD# NUMBER
Yes
SEQUENCE# NUMBER
Yes
FIRST_SCN NUMBER
Yes
NEXT_SCN NUMBER

FIRST_TIME DATE

NEXT_TIME DATE

DICTIONARY_BEGIN VARCHAR2 (3)
DICTIONARY_END VARCHAR2 (3)
KEEP VARCHAR2 (3)
SUSPECT VARCHAR2 (3)
Query Text

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


SELECT LOGMNR_SESSION_ID
,      NAME
,      DBID
,      RESETLOGS_SCN
,      RESETLOGS_TIME
,      MODIFIED_TIME
,      THREAD#
,      SEQUENCE#
,      FIRST_SCN
,      NEXT_SCN
,      FIRST_TIME
,      NEXT_TIME
,      DICTIONARY_BEGIN
,      DICTIONARY_END
,      KEEP
,      SUSPECT
FROM SYS.DBA_LOGMNR_LOG;

Dependencies

[top of page]

SYS.DBA_LOGMNR_LOG references the following:

SchemaSYSTEM
TableLOGMNR_LOG$
SYS.DBA_LOGMNR_LOG is referenced by following:

SchemaPUBLIC
SynonymDBA_LOGMNR_LOG
SchemaSYS
Package BodyDBMS_LOGMNR_INTERNAL - show dependent code