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

TABLE: SYS.LOGMNRG_DICTIONARY$

Object Details
Object Name: LOGMNRG_DICTIONARY$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
DB_NAME VARCHAR2 (9)
DB_ID NUMBER (20)
DB_CREATED VARCHAR2 (20)
DB_DICT_CREATED VARCHAR2 (20)
DB_DICT_SCN NUMBER (22)
DB_THREAD_MAP RAW (8)
DB_TXN_SCNBAS NUMBER (22)
DB_TXN_SCNWRP NUMBER (22)
DB_RESETLOGS_CHANGE# NUMBER (22)
DB_RESETLOGS_TIME VARCHAR2 (20)
DB_VERSION_TIME VARCHAR2 (20)
DB_REDO_TYPE_ID VARCHAR2 (8)
DB_REDO_RELEASE VARCHAR2 (60)
DB_CHARACTER_SET VARCHAR2 (30)
DB_VERSION VARCHAR2 (64)
DB_STATUS VARCHAR2 (64)
DB_GLOBAL_NAME VARCHAR2 (128)
DB_DICT_MAXOBJECTS NUMBER (22)
PDB_NAME VARCHAR2 (30)
PDB_ID NUMBER

PDB_UID NUMBER

PDB_DBID NUMBER

PDB_GUID RAW (16)
PDB_CREATE_SCN NUMBER

PDB_COUNT NUMBER

PDB_GLOBAL_NAME VARCHAR2 (128)
DB_DICT_OBJECTCOUNT NUMBER (22) Yes
Query Text

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


SELECT DB_NAME
,      DB_ID
,      DB_CREATED
,      DB_DICT_CREATED
,      DB_DICT_SCN
,      DB_THREAD_MAP
,      DB_TXN_SCNBAS
,      DB_TXN_SCNWRP
,      DB_RESETLOGS_CHANGE#
,      DB_RESETLOGS_TIME
,      DB_VERSION_TIME
,      DB_REDO_TYPE_ID
,      DB_REDO_RELEASE
,      DB_CHARACTER_SET
,      DB_VERSION
,      DB_STATUS
,      DB_GLOBAL_NAME
,      DB_DICT_MAXOBJECTS
,      PDB_NAME
,      PDB_ID
,      PDB_UID
,      PDB_DBID
,      PDB_GUID
,      PDB_CREATE_SCN
,      PDB_COUNT
,      PDB_GLOBAL_NAME
,      DB_DICT_OBJECTCOUNT
FROM SYS.LOGMNRG_DICTIONARY$;

Dependencies

[top of page]

SYS.LOGMNRG_DICTIONARY$ does not reference any database object

SYS.LOGMNRG_DICTIONARY$ is not referenced by any database object