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

VIEW: SYS.CDB_CAPTURE_PREPARED_TABLES

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

All tables prepared for instantiation in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
TABLE_OWNER VARCHAR2 (30) Yes Owner of the table prepared for instantiation
TABLE_NAME VARCHAR2 (30) 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_CAPTURE_PREPARED_TABLES;

Dependencies

[top of page]

SYS.CDB_CAPTURE_PREPARED_TABLES does not reference any database object

SYS.CDB_CAPTURE_PREPARED_TABLES is referenced by following:

SchemaPUBLIC
SynonymCDB_CAPTURE_PREPARED_TABLES