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: SYS.CDC_CHANGE_TABLES$

Object Details

Object Name:	CDC_CHANGE_TABLES$
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_CDC_CHANGE_TABLES$	NORMAL	UNIQUE	SYSTEM	OBJ#

Columns

Name	Datatype	Length	Mandatory
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

Query Text

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$;

Dependencies

[top of page]

SYS.CDC_CHANGE_TABLES$ does not reference any database object

SYS.CDC_CHANGE_TABLES$ is referenced by following:

SYS: ALL_CHANGE_TABLES; ALL_SOURCE_TAB_COLUMNS; DBA_MVIEW_LOGS; DBA_MVIEW_LOG_FILTER_COLS; DBA_PUBLISHED_COLUMNS; DBA_SNAPSHOT_LOGS; DBA_SOURCE_TABLES; DBA_SOURCE_TAB_COLUMNS; DBA_SUBSCRIBED_COLUMNS; DBA_SUBSCRIBED_TABLES; DBMS_CDC_EXPDP - show dependent code; DBMS_CDC_IMPDP - show dependent code; DBMS_CDC_SYS_IPUBLISH - show dependent code; DBMS_CDC_UTILITY - show dependent code; DBMS_FEATURE_PARTITION_USER - show dependent code; DBMS_OFFLINE_UTL - show dependent code; DBMS_SNAPSHOT_UTL - show dependent code; DBMS_SNAP_INTERNAL - show dependent code; EXU10MVL; EXU9MVL; EXU9MVLCDCCC; EXU9MVLCDCS; EXU9MVLCDCSC; EXU9MVLCDCST; USER_PUBLISHED_COLUMNS; USER_SOURCE_TABLES; USER_SOURCE_TAB_COLUMNS; USER_SUBSCRIBED_COLUMNS; USER_SUBSCRIBED_TABLES