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 | NULL | Description |
|---|---|---|---|
|
|
|
Schema name of the unsupported column |
|
|
|
|
Name of the table that the unsupported column belongs to |
|
|
|
|
Name of the unsupported column |
|
|
|
|
If not a data type issue, displays the reason why the table is unsupported |
|
|
|
|
Data type of the unsupported column |
Note:
This view is available starting with Oracle Database 12c Release 1 (12.1.0.2).
Note:
A rolling upgrade using DBMS_ROLLING supports more object types than a manual rolling upgrade using transient logical standby databases
See Also:
"DBA_LOGSTDBY_UNSUPPORTED" for more information about determining unsupported data types for a manual rolling upgrade operation using transient logical standby databases
Oracle Data Guard Concepts and Administration for more information about rolling operations
Oracle Data Guard Concepts and Administration for more information about unsupported tables for rolling upgrade operations
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_ROLLING package