[Home] [Help] [Dependency Information]
Object Name: | LOGMNR_LOG$ |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
LOGMNR_LOG$_PK | NORMAL | UNIQUE | SYSAUX |
SESSION#
THREAD# SEQUENCE# FIRST_CHANGE# DB_ID RESETLOGS_CHANGE# RESET_TIMESTAMP |
LOGMNR_LOG$_FIRST_CHANGE# | NORMAL | NONUNIQUE | SYSAUX | FIRST_CHANGE# |
LOGMNR_LOG$_FLAGS | NORMAL | NONUNIQUE | SYSAUX | FLAGS |
LOGMNR_LOG$_RECID | NORMAL | NONUNIQUE | SYSAUX | RECID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION# | NUMBER | Yes | ||
THREAD# | NUMBER | Yes | ||
SEQUENCE# | NUMBER | Yes | ||
FIRST_CHANGE# | NUMBER | Yes | ||
NEXT_CHANGE# | NUMBER | |||
FIRST_TIME | DATE | |||
NEXT_TIME | DATE | |||
FILE_NAME | VARCHAR2 | (513) | ||
STATUS | NUMBER | |||
INFO | VARCHAR2 | (32) | ||
TIMESTAMP | DATE | |||
DICT_BEGIN | VARCHAR2 | (3) | ||
DICT_END | VARCHAR2 | (3) | ||
STATUS_INFO | VARCHAR2 | (32) | ||
DB_ID | NUMBER | Yes | ||
RESETLOGS_CHANGE# | NUMBER | Yes | ||
RESET_TIMESTAMP | NUMBER | Yes | ||
PREV_RESETLOGS_CHANGE# | NUMBER | |||
PREV_RESET_TIMESTAMP | NUMBER | |||
BLOCKS | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
FLAGS | NUMBER | |||
CONTENTS | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | NUMBER | |||
SPARE5 | NUMBER | |||
RECID | NUMBER | |||
RECSTAMP | NUMBER | |||
MARK_DELETE_TIMESTAMP | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION#
, THREAD#
, SEQUENCE#
, FIRST_CHANGE#
, NEXT_CHANGE#
, FIRST_TIME
, NEXT_TIME
, FILE_NAME
, STATUS
, INFO
, TIMESTAMP
, DICT_BEGIN
, DICT_END
, STATUS_INFO
, DB_ID
, RESETLOGS_CHANGE#
, RESET_TIMESTAMP
, PREV_RESETLOGS_CHANGE#
, PREV_RESET_TIMESTAMP
, BLOCKS
, BLOCK_SIZE
, FLAGS
, CONTENTS
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, RECID
, RECSTAMP
, MARK_DELETE_TIMESTAMP
FROM SYSTEM.LOGMNR_LOG$;
SYSTEM.LOGMNR_LOG$ does not reference any database object
SYSTEM.LOGMNR_LOG$ is referenced by following:
|
|
|