Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_CAPTURE_PREPARED_TABLES All tables visible to the current user that are prepared for instantiation

Column ID Column name Data type Length Precision NULL Description
1TABLE_OWNERVARCHAR230(null)NOwner of the table prepared for instantiation
2TABLE_NAMEVARCHAR230(null)NName of the table prepared for instantiation
3SCNNUMBER22(null)NSCN from which changes can be captured
4TIMESTAMPDATE7(null)YTime at which the table was ready to be instantiated
5SUPPLEMENTAL_LOG_DATA_PKVARCHAR28(null)YStatus of table-level PRIMARY KEY COLUMNS supplemental logging
6SUPPLEMENTAL_LOG_DATA_UIVARCHAR28(null)YStatus of table-level UNIQUE INDEX COLUMNS supplemental logging
7SUPPLEMENTAL_LOG_DATA_FKVARCHAR28(null)YStatus of table-level FOREIGN KEY COLUMNS supplemental logging
8SUPPLEMENTAL_LOG_DATA_ALLVARCHAR28(null)YStatus of table-level ALL COLUMNS supplemental logging

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:20
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here