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

VIEW: SYS.DBA_CAPTURE_PREPARED_TABLES

Object Details
Object Name: DBA_CAPTURE_PREPARED_TABLES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All tables 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.DBA_CAPTURE_PREPARED_TABLES;

Dependencies

[top of page]

SYS.DBA_CAPTURE_PREPARED_TABLES references the following:

SchemaSYS
TableCDEF$
TableOBJ$
TableSTREAMS$_PREPARE_OBJECT
TableUSER$
SYS.DBA_CAPTURE_PREPARED_TABLES is referenced by following:

SchemaPUBLIC
SynonymDBA_CAPTURE_PREPARED_TABLES
SchemaSYS
ViewALL_CAPTURE_PREPARED_TABLES
Package BodyDBMS_LOGREP_EXP - show dependent code
Package BodyDBMS_STREAMS_ADM_IVK - show dependent code
Package BodyDBMS_STREAMS_DATAPUMP - show dependent code