Oracle教程

Oracle 视图 DBA_ROLLING_SUPPORT_MODE 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图 DBA_ROLLING_SUPPORT_MODE 提供当前实例是否处于滚动支持模式的信息。该视图的目的是帮助DBA确定数据库是否已启用该模式。

滚动支持模式允许数据库管理员在数据库中安装更新补丁而无需停止当前数据库。Oracle 补丁集之间的差异会被称为翻滚，翻滚部件可以对每个数据库中的差异进行详细编排。

使用方法：可以执行以下查询来验证滚动支持模式是否启用:

SELECT rolling_support_mode FROM sys.dba_roll_support_mode;

如果该查询返回布尔值“true”，则说明滚动支持模式已启用。

官方英文解释

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.


数据运维技术 » Oracle 视图 DBA_ROLLING_SUPPORT_MODE 官方解释，作用，如何使用详细说明
分享到：

相关推荐