| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
ALL_CAPTURE_PREPARED_SCHEMAS displays information about the schemas prepared for instantiation that are accessible to the current user at the local database.
Related View
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:
|
