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: SYSTEM.LOGMNRGGC_GTLO

Object Details

Object Name:	LOGMNRGGC_GTLO
Object Type:	TABLE
Owner:	SYSTEM
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: LOGMNRGGC_GTLO_PK

LOGMNR_UID
KEYOBJ#
BASEOBJV#

Indexes

Index	Type	Uniqueness	Tablespace	Column
LOGMNRGGC_GTLO_PK	NORMAL	UNIQUE	SYSTEM	LOGMNR_UID KEYOBJ# BASEOBJV#
LOGMNRGGC_I2GTLO	NORMAL	NONUNIQUE	SYSTEM	LOGMNR_UID BASEOBJ# BASEOBJV#
LOGMNRGGC_I3GTLO	NORMAL	NONUNIQUE	SYSTEM	LOGMNR_UID DROP_SCN

Columns

Name	Datatype	Length	Mandatory
LOGMNR_UID	NUMBER		Yes
KEYOBJ#	NUMBER		Yes
LVLCNT	NUMBER		Yes
BASEOBJ#	NUMBER		Yes
BASEOBJV#	NUMBER		Yes
LVL1OBJ#	NUMBER
LVL2OBJ#	NUMBER
LVL0TYPE#	NUMBER		Yes
LVL1TYPE#	NUMBER
LVL2TYPE#	NUMBER
OWNER#	NUMBER
OWNERNAME	VARCHAR2	(128)	Yes
LVL0NAME	VARCHAR2	(128)	Yes
LVL1NAME	VARCHAR2	(128)
LVL2NAME	VARCHAR2	(128)
INTCOLS	NUMBER		Yes
COLS	NUMBER
KERNELCOLS	NUMBER
TAB_FLAGS	NUMBER
TRIGFLAG	NUMBER
ASSOC#	NUMBER
OBJ_FLAGS	NUMBER
TS#	NUMBER
TSNAME	VARCHAR2	(30)
PROPERTY	NUMBER
START_SCN	NUMBER		Yes
DROP_SCN	NUMBER
XIDUSN	NUMBER
XIDSLT	NUMBER
XIDSQN	NUMBER
FLAGS	NUMBER
LOGMNR_SPARE1	NUMBER
LOGMNR_SPARE2	NUMBER
LOGMNR_SPARE3	VARCHAR2	(1000)
LOGMNR_SPARE4	DATE
LOGMNR_SPARE5	NUMBER
LOGMNR_SPARE6	NUMBER
LOGMNR_SPARE7	NUMBER
LOGMNR_SPARE8	NUMBER
LOGMNR_SPARE9	NUMBER
PARTTYPE	NUMBER
SUBPARTTYPE	NUMBER
UNSUPPORTEDCOLS	NUMBER
COMPLEXTYPECOLS	NUMBER
NTPARENTOBJNUM	NUMBER
NTPARENTOBJVERSION	NUMBER
NTPARENTINTCOLNUM	NUMBER
LOGMNRTLOFLAGS	NUMBER
LOGMNRMCV	VARCHAR2	(30)

Query Text

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


SELECT LOGMNR_UID
,      KEYOBJ#
,      LVLCNT
,      BASEOBJ#
,      BASEOBJV#
,      LVL1OBJ#
,      LVL2OBJ#
,      LVL0TYPE#
,      LVL1TYPE#
,      LVL2TYPE#
,      OWNER#
,      OWNERNAME
,      LVL0NAME
,      LVL1NAME
,      LVL2NAME
,      INTCOLS
,      COLS
,      KERNELCOLS
,      TAB_FLAGS
,      TRIGFLAG
,      ASSOC#
,      OBJ_FLAGS
,      TS#
,      TSNAME
,      PROPERTY
,      START_SCN
,      DROP_SCN
,      XIDUSN
,      XIDSLT
,      XIDSQN
,      FLAGS
,      LOGMNR_SPARE1
,      LOGMNR_SPARE2
,      LOGMNR_SPARE3
,      LOGMNR_SPARE4
,      LOGMNR_SPARE5
,      LOGMNR_SPARE6
,      LOGMNR_SPARE7
,      LOGMNR_SPARE8
,      LOGMNR_SPARE9
,      PARTTYPE
,      SUBPARTTYPE
,      UNSUPPORTEDCOLS
,      COMPLEXTYPECOLS
,      NTPARENTOBJNUM
,      NTPARENTOBJVERSION
,      NTPARENTINTCOLNUM
,      LOGMNRTLOFLAGS
,      LOGMNRMCV
FROM SYSTEM.LOGMNRGGC_GTLO;

Dependencies

[top of page]

SYSTEM.LOGMNRGGC_GTLO does not reference any database object

SYSTEM.LOGMNRGGC_GTLO is referenced by following:

SYS: LOGMNR_DICT_CACHE - show dependent code; LOGMNR_GTLO3 - show dependent code