Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


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(30) NOT NULL Owner of the table that is ready to be instiated
TABLE_NAME VARCHAR2(30) NOT NULL Name of the table that is ready to be instiated
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