Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

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

Go to previous page Go to next page
View PDF

ALL_CAPTURE_PREPARED_TABLES

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)

Owner of the table prepared for instantiation

TABLE_NAME

VARCHAR2(30)

Name of the table prepared for instantiation

SCN

NUMBER

NOT NULL

Smallest system change number (SCN) for which the table can be instantiated

TIMESTAMP

DATE

Time when the table was prepared for instantiation

See Also:

"DBA_CAPTURE_PREPARED_TABLES"