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_CAPTURE_PREPARED_TABLES

Object Details

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

All tables visible to the current user that are prepared for instantiation

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TABLE_OWNER	VARCHAR2	(128)	Yes	Owner of the table prepared for instantiation
TABLE_NAME	VARCHAR2	(128)	Yes	Name of the table prepared for instantiation
SCN	NUMBER		Yes	SCN from which changes can be captured
TIMESTAMP	DATE			Time at which the table was ready to be instantiated
SUPPLEMENTAL_LOG_DATA_PK	VARCHAR2	(8)		Status of table-level PRIMARY KEY COLUMNS supplemental logging
SUPPLEMENTAL_LOG_DATA_UI	VARCHAR2	(8)		Status of table-level UNIQUE INDEX COLUMNS supplemental logging
SUPPLEMENTAL_LOG_DATA_FK	VARCHAR2	(8)		Status of table-level FOREIGN KEY COLUMNS supplemental logging
SUPPLEMENTAL_LOG_DATA_ALL	VARCHAR2	(8)		Status of table-level ALL COLUMNS supplemental logging

Query Text

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


SELECT TABLE_OWNER
,      TABLE_NAME
,      SCN
,      TIMESTAMP
,      SUPPLEMENTAL_LOG_DATA_PK
,      SUPPLEMENTAL_LOG_DATA_UI
,      SUPPLEMENTAL_LOG_DATA_FK
,      SUPPLEMENTAL_LOG_DATA_ALL
FROM SYS.ALL_CAPTURE_PREPARED_TABLES;

Dependencies

[top of page]

SYS.ALL_CAPTURE_PREPARED_TABLES references the following:

SYS: ALL_TABLES; DBA_CAPTURE_PREPARED_TABLES

SYS.ALL_CAPTURE_PREPARED_TABLES is referenced by following:

PUBLIC: ALL_CAPTURE_PREPARED_TABLES
SYS: DBMS_STREAMS_DATAPUMP - show dependent code