6.302 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

Note:

This view is available starting with Oracle Database 21c.