2.72 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(128)

NOT NULL

Owner of the table that is ready to be instantiated

TABLE_NAME

VARCHAR2(128)

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