Skip to content

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

VIEW: SYS.LOGMNR_TAB_COLS_SUPPORT

Object Details
Object Name: LOGMNR_TAB_COLS_SUPPORT
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOGMNR_UID NUMBER (22)
OBJ# NUMBER (22) Yes
OWNER# NUMBER (22)
OWNER VARCHAR2 (128) Yes
TABLE_NAME VARCHAR2 (128)
COLUMN_NAME VARCHAR2 (128)
TYPE# NUMBER (22)
DATA_TYPE VARCHAR2 (128)
DATA_TYPE_MOD VARCHAR2 (3)
DATA_TYPE_OWNER VARCHAR2 (128)
DATA_LENGTH NUMBER (22)
DATA_PRECISION NUMBER (22)
DATA_SCALE NUMBER (22)
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 (22)
QUALIFIED_COL_NAME VARCHAR2 (4000)
Query Text

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


SELECT LOGMNR_UID
,      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_SUPPORT;

Dependencies

[top of page]

SYS.LOGMNR_TAB_COLS_SUPPORT references the following:

SchemaSYSTEM
TableLOGMNR_ATTRCOL$
TableLOGMNR_COL$
TableLOGMNR_COLTYPE$
TableLOGMNR_OBJ$
TableLOGMNR_TAB$
TableLOGMNR_USER$
SYS.LOGMNR_TAB_COLS_SUPPORT is referenced by following:

SchemaSYS
ViewLOGMNR_GTCS_SUPPORT