DBA_LOGSTDBY_UNSUPPORTED

6.174 DBA_LOGSTDBY_UNSUPPORTED_TABLE

DBA_LOGSTDBY_UNSUPPORTED_TABLE displays the data tables 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.

The data displayed pertains to the container in which the view is queried.

Column Datatype NULL Description

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Owner of the unsupported table
`TABLE_NAME`	`VARCHAR2(128)`	Name of the unsupported table
`EXPLANATION`^Foot 1	`VARCHAR2(4000)`	If the database is currently undergoing a manual rolling upgrade performed using transient logical standby databases, then this column displays the reason the table is unsupported for transient logical standby. Otherwise, this column displays the reason the table is unsupported for logical standby. This column is populated only when the value of the `COMPATIBLE` initialization parameter is `20.0` or higher.

OWNER

VARCHAR2(128)

Owner of the unsupported table

TABLE_NAME

VARCHAR2(128)

Name of the unsupported table

EXPLANATION^Foot 1

VARCHAR2(4000)

If the database is currently undergoing a manual rolling upgrade performed using transient logical standby databases, then this column displays the reason the table is unsupported for transient logical standby. Otherwise, this column displays the reason the table is unsupported for logical standby.

This column is populated only when the value of the COMPATIBLE initialization parameter is 20.0 or higher.

^Footnote 1This column is available starting with Oracle Database 21c.