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

本站中文解释

Oracle视图DBA_LOGSTDBY_UNSUPPORTED_TABLE是一个数据字典视图,该视图显示当前在记录日志数据库环境中不受支持的表。

使用Oracle视图DBA_LOGSTDBY_UNSUPPORTED_TABLE:

1. 在SQL查询中输入SELECT * FROM DBA_LOGSTDBY_UNSUPPORTED_TABLE,这将列出当前记录日志数据库环境中不受支持的表;

2. 您可以使用查询来查找特定表名称在此视图中;

3. 您可以使用DBA_LOGSTDBY_UNSUPPORTED_TABLE视图进行基于表的管理和维护;

4. 您可以使用此视图来检查哪些表尚未完成LOGSTDBY迁移和准备工作,以便完成数据库的同步操作。

官方英文解释

DBA_LOGSTDBY_UNSUPPORTED_TABLE displays the data tables that are unsupported by logical standby.

The query results for this view depend on whether the database is currently undergoing a manual rolling upgrade performed using transient logical standby databases. If the database is undergoing such an upgrade, then this view displays information about tables in the database that are unsupported for transient logical standby. If the database is not undergoing such an upgrade, then this view displays information about tables in the database are unsupported for logical standby.

The data displayed pertains to the container in which the view is queried.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the unsupported table

TABLE_NAME

VARCHAR2(128)

Name of the unsupported table

EXPLANATIONFoot 1

VARCHAR2(4000)

If the database is currently undergoing a manual rolling upgrade performed using transient logical standby databases, then this column displays the reason the table is unsupported for transient logical standby. Otherwise, this column displays the reason the table is unsupported for logical standby.

This column is populated only when the value of the COMPATIBLE initialization parameter is 20.0 or higher.

Footnote 1 This column is available starting with Oracle Database 21c.


数据运维技术 » Oracle 视图 DBA_LOGSTDBY_UNSUPPORTED_TABLE 官方解释,作用,如何使用详细说明