Oracle 视图 DBA_ROLLING_UNSUPPORTED 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ROLLING_UNSUPPORTED记录所有Oracle服务器实例上受支持但不支持“滚动”更新的组件的信息。
这个视图可以帮助DBA更有效地更新他们的Oracle实例，例如在更新补丁或对实例进行升级时。
使用方法： DBA首先可以执行以下查询以检索他们Oracle服务器实例上不支持“滚动”更新的组件信息:
SELECT * FROM DBA_ROLLING_UNSUPPORTED;
这将显示因它们不支持“滚动”更新而无法通过实例的补丁集进行更新的组件的详细信息，其中包括程序文件的名称、版本号、存储位置等信息。 DBA可以使用此信息来确定如何对其进行更新。
官方英文解释
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 |
|
|
|
|
When the value of the Otherwise, this column displays the reason the table is unsupported only if the reason is not a data type issue. |
|
|
|
|
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
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 theDBMS_ROLLINGpackage
