Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_CAPTURE_PREPARED_TABLES

ALL_CAPTURE_PREPARED_TABLES displays information about the tables prepared for instantiation that are accessible to the current user at the local database.

Related View

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:
  • IMPLICIT

  • EXPLICIT

  • NO

SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(8)   Status of table-level UNIQUE INDEX COLUMNS supplemental logging:
  • IMPLICIT

  • EXPLICIT

  • NO

SUPPLEMENTAL_LOG_DATA_FK VARCHAR2(8)   Status of table-level FOREIGN KEY COLUMNS supplemental logging:
  • IMPLICIT

  • EXPLICIT

  • NO

SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2(8)   Status of table-level ALL COLUMNS supplemental logging:
  • IMPLICIT

  • EXPLICIT

  • NO


See Also: