Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
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
REFRN23128

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)   Owner of the unsupported table
TABLE_NAME VARCHAR2(30)   Name of the unsupported table
COLUMN_NAME VARCHAR2(30)   Name 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), then 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

  • AQ queue table

  • Unsupported Virtual Column

  • 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.

DATA_TYPE VARCHAR2(32)   Datatype of the unsupported column

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF