DBA_ROLLING_UNSUPPORTED

6.305 DBA_ROLLING_UNSUPPORTED

DBA_ROLLING_UNSUPPORTED displays the schemas, tables, and columns in those tables that contain unsupported data types for a rolling upgrade operation for a logical standby database using the DBMS_ROLLING PL/SQL package.

Use this view before you perform a rolling upgrade using DBMS_ROLLING to determine what is unsupported.

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

Column	Datatype	Description
`OWNER`	`VARCHAR2(128)`	Schema name of the unsupported column
`TABLE_NAME`	`VARCHAR2(128)`	Name of the table that the unsupported column belongs to
`COLUMN_NAME`	`VARCHAR2(128)`	Name of the unsupported column
`ATTRIBUTES`	`VARCHAR2(4000)`	When the value of the `COMPATIBLE` initialization parameter is `20.0` or higher, this column displays the reason the table is unsupported. Otherwise, this column displays the reason the table is unsupported only if the reason is not a data type issue.
`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 using DBMS_ROLLING supports more object types than a manual rolling upgrade using transient logical standby databases