| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
ALL_CAPTURE_PREPARED_TABLES displays information about the tables prepared for instantiation that are accessible to the current user at the local database.
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: 
 | |
| SUPPLEMENTAL_LOG_DATA_UI | VARCHAR2(8) | Status of table-level UNIQUE INDEX COLUMNS supplemental logging: 
 | |
| SUPPLEMENTAL_LOG_DATA_FK | VARCHAR2(8) | Status of table-level FOREIGN KEY COLUMNS supplemental logging: 
 | |
| SUPPLEMENTAL_LOG_DATA_ALL | VARCHAR2(8) | Status of table-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