ALL_CAPTURE_PREPARED_TABLES
displays information about the tables prepared for instantiation that are accessible to the current user at the local database.
DBA_CAPTURE_PREPARED_TABLES
displays information about all tables prepared for instantiation at the local database.
Column | Datatype | NULL | Description |
---|---|---|---|
TABLE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the table that is ready to be instantiated |
TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the table that is ready to be instantiated |
SCN |
NUMBER |
NOT NULL |
Smallest system change number (SCN) for which the table can be instantiated |
TIMESTAMP |
DATE |
Date and 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 |
See Also:
Oracle Streams Replication Administrator's Guide for more information about the possible values for the supplemental logging columns in this view