DBA_LOGSTDBY_UNSUPPORTED

6.173 DBA_LOGSTDBY_UNSUPPORTED

DBA_LOGSTDBY_UNSUPPORTED displays the schemas, tables, and columns in those tables that contain data types that are unsupported by logical standby.

The query results for this view depend on whether the database is currently undergoing a manual rolling upgrade performed using transient logical standby databases. If the database is undergoing such an upgrade, then this view displays information about tables in the database that are unsupported for transient logical standby. If the database is not undergoing such an upgrade, then this view displays information about tables in the database are unsupported for logical standby.

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Owner of the unsupported table
`TABLE_NAME`	`VARCHAR2(128)`	Name of the unsupported table
`COLUMN_NAME`	`VARCHAR2(128)`	Name of the unsupported column
`ATTRIBUTES`	`VARCHAR2(4000)`	If the database is currently undergoing a manual rolling upgrade performed using transient logical standby databases and the value of the `COMPATIBLE` initialization parameter is `20.0` or higher, then this column displays the reason the table is unsupported by SQL Apply.
`DATA_TYPE`	`VARCHAR2(106)`	Data type of the unsupported column

Note:

When the value of the COMPATIBLE initialization parameter is 20.0 or higher, this view displays all columns in unsupported tables. Otherwise, this view displays only the unsupported columns in unsupported tables.

Note:

A rolling upgrade performed using the DBMS_ROLLING PL/SQL package supports more object types than a manual rolling upgrade performed using transient logical standby databases.