DBA_ROLLING_SUPPORT_MODE

DBA_ROLLING_SUPPORT_MODE displays information about whether tables in the database are supported for rolling upgrades performed using the DBMS_ROLLING package.

Column Datatype NULL Description
OWNER VARCHAR2(128)   Table owner
TABLE_NAME VARCHAR2(128)   Table name
SUPPORT_MODE VARCHAR2(11)  

Indicates whether the table is supported

Possible values:

  • SUPPORTED - The table is fully supported

  • INTERNAL - The table is not supported because it contains data that should not be replicated. Such tables include mapping tables for index-organized tables, storage tables for nested tables, materialized view logs, secondary objects associated with domain indexes, and temporary tables.

  • UNSUPPORTED - The table is not supported because it contains a data type that is not supported or uses a feature that is not supported

EXPLANATION VARCHAR2(4000)  

Reason why the table is not fully supported

This column is populated only when both of the following conditions are met:

  • The value of the COMPATIBLE initialization parameter is 20.0 or higher
  • The value of the SUPPORT_MODE column is INTERNAL or UNSUPPORTED