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


TABLE: SYS.CDC_CHANGE_COLUMNS$

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
I_CDC_CHANGE_COLUMNS$ NORMAL UNIQUE TablespaceSYSTEM ColumnCHANGE_TABLE_OBJ#
ColumnCOLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
CHANGE_TABLE_OBJ# NUMBER
Yes
COLUMN_NAME VARCHAR2 (128) Yes
CREATED DATE
Yes
CREATED_SCN NUMBER
Yes
Query Text

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


SELECT CHANGE_TABLE_OBJ#
,      COLUMN_NAME
,      CREATED
,      CREATED_SCN
FROM SYS.CDC_CHANGE_COLUMNS$;

Dependencies

[top of page]

SYS.CDC_CHANGE_COLUMNS$ does not reference any database object

SYS.CDC_CHANGE_COLUMNS$ is referenced by following:

SchemaSYS
ViewDBA_MVIEW_LOG_FILTER_COLS
Package BodyDBMS_CDC_EXPDP - show dependent code
Package BodyDBMS_CDC_IMPDP - show dependent code
Package BodyDBMS_CDC_SYS_IPUBLISH - show dependent code
ViewEXU9MVLCDCCC