Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
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
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_LOGSTDBY_UNSUPPORTED

DBA_LOGSTDBY_UNSUPPORTED displays the schemas, tables, and columns in those tables that contain unsupported datatypes. Use this view when you are preparing to create a logical standby database. This view is for logical standby databases only.

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Schema name of the unsupported table
TABLE_NAME VARCHAR2(30) NOT NULL Name of the unsupported table
COLUMN_NAME VARCHAR2(30) NOT NULL Name of the unsupported column
DATA_TYPE VARCHAR2(106)   Datatype of the unsupported column
ATTRIBUTES VARCHAR2(39)   Displays the reason why the table is not supported by SQL Apply. If the structure of the table is unsupported (not just the datatype of some columns), this view displays all columns in the table, with one of the following values displayed for each column in the table:
  • IOT with Overflow

  • IOT with LOB

  • Mapping table for physical rowid of IOT

  • IOT with row movement

  • Table Compression

  • Object Table

  • Table with encrypted column

If the structure of the table is supported but certain columns in the table have unsupported datatypes, the ATTRIBUTE column will be NULL.