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.ALL_CHANGE_TABLES

Object Details

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

Change Data Capture change tables

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHANGE_TABLE_SCHEMA	VARCHAR2	(128)	Yes	Owner of the change table
CHANGE_TABLE_NAME	VARCHAR2	(128)	Yes	Name of the change table
CHANGE_SET_NAME	VARCHAR2	(128)	Yes	Change set to which change table belongs
SOURCE_SCHEMA_NAME	VARCHAR2	(128)	Yes	Owner of the source table for the change table
SOURCE_TABLE_NAME	VARCHAR2	(128)	Yes	Name of the source table for the change table
CREATED	DATE		Yes	Creation date of the change table
CREATED_SCN	NUMBER			Creation SCN of the change table
CAPTURED_VALUES	CHAR	(1)	Yes	Indicates whether OLD, NEW or BOTH update values are captured
PUB_ID	NUMBER		Yes	Publication ID displayed to subscribers for the change table

Query Text

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


SELECT CHANGE_TABLE_SCHEMA
,      CHANGE_TABLE_NAME
,      CHANGE_SET_NAME
,      SOURCE_SCHEMA_NAME
,      SOURCE_TABLE_NAME
,      CREATED
,      CREATED_SCN
,      CAPTURED_VALUES
,      PUB_ID
FROM SYS.ALL_CHANGE_TABLES;

Dependencies

[top of page]

SYS.ALL_CHANGE_TABLES references the following:

SYS: CDC_CHANGE_TABLES$

SYS.ALL_CHANGE_TABLES is referenced by following:

PUBLIC: ALL_CHANGE_TABLES; CHANGE_TABLES