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]

VIEW: SYS.LOGMNR_TAB_COLS_CAT_SUPPORT

Object Details

Object Name:	LOGMNR_TAB_COLS_CAT_SUPPORT
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
OBJ#	NUMBER		Yes
OWNER#	NUMBER		Yes
OWNER	VARCHAR2	(128)	Yes
TABLE_NAME	VARCHAR2	(128)	Yes
COLUMN_NAME	VARCHAR2	(128)	Yes
TYPE#	NUMBER		Yes
DATA_TYPE	VARCHAR2	(128)
DATA_TYPE_MOD	VARCHAR2	(3)
DATA_TYPE_OWNER	VARCHAR2	(128)
DATA_LENGTH	NUMBER		Yes
DATA_PRECISION	NUMBER
DATA_SCALE	NUMBER
NULLABLE	VARCHAR2	(1)
COLUMN_ID	NUMBER
CHARACTER_SET_NAME	VARCHAR2	(44)
CHAR_COL_DECL_LENGTH	NUMBER
CHAR_USED	VARCHAR2	(1)
V80_FMT_IMAGE	VARCHAR2	(3)
HIDDEN_COLUMN	VARCHAR2	(3)
VIRTUAL_COLUMN	VARCHAR2	(3)
SEGMENT_COLUMN_ID	NUMBER
INTERNAL_COLUMN_ID	NUMBER		Yes
QUALIFIED_COL_NAME	VARCHAR2	(4000)

Query Text

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


SELECT OBJ#
,      OWNER#
,      OWNER
,      TABLE_NAME
,      COLUMN_NAME
,      TYPE#
,      DATA_TYPE
,      DATA_TYPE_MOD
,      DATA_TYPE_OWNER
,      DATA_LENGTH
,      DATA_PRECISION
,      DATA_SCALE
,      NULLABLE
,      COLUMN_ID
,      CHARACTER_SET_NAME
,      CHAR_COL_DECL_LENGTH
,      CHAR_USED
,      V80_FMT_IMAGE
,      HIDDEN_COLUMN
,      VIRTUAL_COLUMN
,      SEGMENT_COLUMN_ID
,      INTERNAL_COLUMN_ID
,      QUALIFIED_COL_NAME
FROM SYS.LOGMNR_TAB_COLS_CAT_SUPPORT;

Dependencies

[top of page]

SYS.LOGMNR_TAB_COLS_CAT_SUPPORT references the following:

SYS: ATTRCOL$; COL$; COLTYPE$; OBJ$; TAB$; USER$

SYS.LOGMNR_TAB_COLS_CAT_SUPPORT is referenced by following:

SYS: LOGMNR_GTCS_CAT_SUPPORT