ALL_CAPTURE_PREPARED_SCHEMAS

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

DBA_CAPTURE_PREPARED_SCHEMAS displays information about all schemas prepared for instantiation at the local database.

Column Datatype NULL Description
SCHEMA_NAME VARCHAR2(128) NOT NULL Name of the schema that is ready to be instantiated
TIMESTAMP DATE   Date and time at which the schema was ready to be instantiated
SUPPLEMENTAL_LOG_DATA_PK VARCHAR2(8)  

Status of schema-level PRIMARY KEY COLUMNS supplemental logging:

  • IMPLICIT

  • EXPLICIT

  • NO
SUPPLEMENTAL_LOG_DATA_UI VARCHAR2(8)  

Status of schema-level UNIQUE INDEX COLUMNS supplemental logging:

  • IMPLICIT

  • EXPLICIT

  • NO
SUPPLEMENTAL_LOG_DATA_FK VARCHAR2(8)  

Status of schema-level FOREIGN KEY COLUMNS supplemental logging:

  • IMPLICIT

  • EXPLICIT

  • NO
SUPPLEMENTAL_LOG_DATA_ALL VARCHAR2(8)  

Status of schema-level ALL COLUMNS supplemental logging:

  • IMPLICIT

  • EXPLICIT

  • NO

See Also: “DBA_CAPTURE_PREPARED_SCHEMAS”