| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
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(30) | 
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:
  | 
|
SUPPLEMENTAL_LOG_DATA_UI | 
VARCHAR2(8) | 
Status of schema-level UNIQUE INDEX COLUMNS supplemental logging:
  | 
|
SUPPLEMENTAL_LOG_DATA_FK | 
VARCHAR2(8) | 
Status of schema-level FOREIGN KEY COLUMNS supplemental logging:
  | 
|
SUPPLEMENTAL_LOG_DATA_ALL | 
VARCHAR2(8) | 
Status of schema-level ALL COLUMNS supplemental logging:
  | 
See Also:
Oracle Streams Concepts and Administration for more information about the possible values for the supplemental logging columns in this view