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.LOGMNRC_GTCS

Object Details

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

Storage Details

Tablespace:
PCT Free:
PCT Used:

Primary Key: LOGMNRC_GTCS_PK

LOGMNR_UID
OBJ#
OBJV#
INTCOL#

Indexes

Index	Type	Uniqueness	Tablespace	Column
LOGMNRC_GTCS_PK	NORMAL	UNIQUE		LOGMNR_UID OBJ# OBJV# INTCOL#
LOGMNRC_I2GTCS	NORMAL	NONUNIQUE		LOGMNR_UID OBJ# OBJV# SEGCOL# INTCOL#

Columns

Name	Datatype	Length	Mandatory
LOGMNR_UID	NUMBER		Yes
OBJ#	NUMBER		Yes
OBJV#	NUMBER		Yes
SEGCOL#	NUMBER		Yes
INTCOL#	NUMBER		Yes
COLNAME	VARCHAR2	(128)	Yes
TYPE#	NUMBER		Yes
LENGTH	NUMBER
PRECISION	NUMBER
SCALE	NUMBER
INTERVAL_LEADING_PRECISION	NUMBER
INTERVAL_TRAILING_PRECISION	NUMBER
PROPERTY	NUMBER
TOID	RAW	(16)
CHARSETID	NUMBER
CHARSETFORM	NUMBER
TYPENAME	VARCHAR2	(128)
FQCOLNAME	VARCHAR2	(4000)
NUMINTCOLS	NUMBER
NUMATTRS	NUMBER
ADTORDER	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
COL#	NUMBER
XTYPESCHEMANAME	VARCHAR2	(128)
XTYPENAME	VARCHAR2	(4000)
XFQCOLNAME	VARCHAR2	(4000)
XTOPINTCOL	NUMBER
XREFFEDTABLEOBJN	NUMBER
XREFFEDTABLEOBJV	NUMBER
XCOLTYPEFLAGS	NUMBER
XOPQTYPETYPE	NUMBER
XOPQTYPEFLAGS	NUMBER
XOPQLOBINTCOL	NUMBER
XOPQOBJINTCOL	NUMBER
XXMLINTCOL	NUMBER
EAOWNER#	NUMBER
EAMKEYID	VARCHAR2	(64)
EAENCALG	NUMBER
EAINTALG	NUMBER
EACOLKLC	RAW	(2000)
EAKLCLEN	NUMBER
EAFLAGS	NUMBER
LOGMNRDERIVEDFLAGS	NUMBER

Query Text

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


SELECT LOGMNR_UID
,      OBJ#
,      OBJV#
,      SEGCOL#
,      INTCOL#
,      COLNAME
,      TYPE#
,      LENGTH
,      PRECISION
,      SCALE
,      INTERVAL_LEADING_PRECISION
,      INTERVAL_TRAILING_PRECISION
,      PROPERTY
,      TOID
,      CHARSETID
,      CHARSETFORM
,      TYPENAME
,      FQCOLNAME
,      NUMINTCOLS
,      NUMATTRS
,      ADTORDER
,      LOGMNR_SPARE1
,      LOGMNR_SPARE2
,      LOGMNR_SPARE3
,      LOGMNR_SPARE4
,      LOGMNR_SPARE5
,      LOGMNR_SPARE6
,      LOGMNR_SPARE7
,      LOGMNR_SPARE8
,      LOGMNR_SPARE9
,      COL#
,      XTYPESCHEMANAME
,      XTYPENAME
,      XFQCOLNAME
,      XTOPINTCOL
,      XREFFEDTABLEOBJN
,      XREFFEDTABLEOBJV
,      XCOLTYPEFLAGS
,      XOPQTYPETYPE
,      XOPQTYPEFLAGS
,      XOPQLOBINTCOL
,      XOPQOBJINTCOL
,      XXMLINTCOL
,      EAOWNER#
,      EAMKEYID
,      EAENCALG
,      EAINTALG
,      EACOLKLC
,      EAKLCLEN
,      EAFLAGS
,      LOGMNRDERIVEDFLAGS
FROM SYSTEM.LOGMNRC_GTCS;

Dependencies

[top of page]

SYSTEM.LOGMNRC_GTCS does not reference any database object

SYSTEM.LOGMNRC_GTCS is referenced by following:

SYS: LOGMNR_DICT_CACHE - show dependent code
SYSTEM: LOGMNR$COL_GG_TABF_PUBLIC; LOGMNR$KEY_GG_TABF_PUBLIC