[Home] [Help] [Dependency Information]
Object Name: | CDC_CHANGE_TABLES$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_CDC_CHANGE_TABLES$ | NORMAL | UNIQUE | SYSTEM | OBJ# |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJ# | NUMBER | Yes | ||
CHANGE_SET_NAME | VARCHAR2 | (128) | Yes | |
SOURCE_SCHEMA_NAME | VARCHAR2 | (128) | Yes | |
SOURCE_TABLE_NAME | VARCHAR2 | (128) | Yes | |
CHANGE_TABLE_SCHEMA | VARCHAR2 | (128) | Yes | |
CHANGE_TABLE_NAME | VARCHAR2 | (128) | Yes | |
CREATED | DATE | Yes | ||
CREATED_SCN | NUMBER | |||
MVL_FLAG | NUMBER | |||
CAPTURED_VALUES | CHAR | (1) | Yes | |
MVL_TEMP_LOG | VARCHAR2 | (128) | ||
MVL_V7TRIGGER | VARCHAR2 | (128) | ||
LAST_ALTERED | DATE | |||
LOWEST_SCN | NUMBER | Yes | ||
MVL_OLDEST_RID | NUMBER | |||
MVL_OLDEST_PK | NUMBER | |||
MVL_OLDEST_OID | NUMBER | |||
MVL_OLDEST_NEW | NUMBER | |||
MVL_OLDEST_RID_TIME | DATE | |||
MVL_OLDEST_PK_TIME | DATE | |||
MVL_OLDEST_OID_TIME | DATE | |||
MVL_OLDEST_NEW_TIME | DATE | |||
MVL_BACKCOMPAT_VIEW | VARCHAR2 | (128) | ||
MVL_PHYSMVL | VARCHAR2 | (128) | ||
HIGHEST_SCN | NUMBER | |||
HIGHEST_TIMESTAMP | DATE | |||
CHANGE_TABLE_TYPE | NUMBER | Yes | ||
MAJOR_VERSION | NUMBER | Yes | ||
MINOR_VERSION | NUMBER | Yes | ||
MVL_OLDEST_SEQ | NUMBER | |||
MVL_OLDEST_SEQ_TIME | DATE | |||
SOURCE_TABLE_OBJ# | NUMBER | |||
SOURCE_TABLE_VER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, CHANGE_SET_NAME
, SOURCE_SCHEMA_NAME
, SOURCE_TABLE_NAME
, CHANGE_TABLE_SCHEMA
, CHANGE_TABLE_NAME
, CREATED
, CREATED_SCN
, MVL_FLAG
, CAPTURED_VALUES
, MVL_TEMP_LOG
, MVL_V7TRIGGER
, LAST_ALTERED
, LOWEST_SCN
, MVL_OLDEST_RID
, MVL_OLDEST_PK
, MVL_OLDEST_OID
, MVL_OLDEST_NEW
, MVL_OLDEST_RID_TIME
, MVL_OLDEST_PK_TIME
, MVL_OLDEST_OID_TIME
, MVL_OLDEST_NEW_TIME
, MVL_BACKCOMPAT_VIEW
, MVL_PHYSMVL
, HIGHEST_SCN
, HIGHEST_TIMESTAMP
, CHANGE_TABLE_TYPE
, MAJOR_VERSION
, MINOR_VERSION
, MVL_OLDEST_SEQ
, MVL_OLDEST_SEQ_TIME
, SOURCE_TABLE_OBJ#
, SOURCE_TABLE_VER
FROM SYS.CDC_CHANGE_TABLES$;
SYS.CDC_CHANGE_TABLES$ does not reference any database object
SYS.CDC_CHANGE_TABLES$ is referenced by following:
|
|
|