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

本站中文解释

Oracle 视图 DBA_REDEFINITION_STATUS 提供了有关数据库中特定表重定义操作的信息。它包括有关正在进行的重定义操作的状态和错误信息,以及用于重定义操作的实例 ID 和操作 ID。

使用 DBA_REDEFINITION_STATUS 视图的主要用途是掌握正在重定义表时遇到的问题,从而及时制定针对任何错误或失败的重定义操作的恢复策略。

使用步骤:
1. 查看正在进行的重定义操作:
SELECT * FROM DBA_REDEFINITION_STATUS WHERE STATUS != ‘COMPLETED’;

2. 查看指定表已完成的重定义操作:
SELECT * FROM DBA_REDEFINITION_STATUS WHERE OWNER=’OWNER’ AND TABLE_NAME=’TABLE_NAME’ AND STATUS=’COMPLETED’;

3. 为了获取重定义表时出现错误或失败的相关信息,可以查看 DBA_REDEFINITION_ERRORS 视图:
SELECT * FROM DBA_REDEFINITION_ERRORS;

官方英文解释

DBA_REDEFINITION_STATUS is an online redefinition view. It provides information about the online redefinition status.

Column Datatype NULL Description

REDEFINITION_ID

NUMBER(38)

NOT NULL

ID for the redefinition object

BASE_TABLE_OWNER

VARCHAR2(128)

Owner of the base table of the redefinition object

BASE_TABLE_NAME

VARCHAR2(128)

Name of the base table of the redefinition object

BASE_OBJECT_NAME

VARCHAR2(128)

NOT NULL

Name of the base object of the redefinition object

BASE_OBJECT_TYPE

VARCHAR2(9)

Type of the base object of the redefinition object

INTERIM_OBJECT_OWNER

VARCHAR2(128)

Owner of the interim object of the redefinition object

INTERIM_OBJECT_NAME

VARCHAR2(128)

Name of the interim object of the redefinition object

OPERATION

VARCHAR2(128)

NOT NULL

The current redefinition operation:

  • START_REDEF_TABLE

  • SYNC_INTERIM_TABLE

  • COPY_TABLE_DEPENDENTS

  • FINISH_REDEF_TABLE

STATUS

VARCHAR2(128)

NOT NULL

Status of the previous redefinition operation:

  • FAILURE

  • SUCCESS

RESTARTABLE

VARCHAR2(1)

NOT NULL

Indicates whether the previous operation can be restarted

ERR_TXT

VARCHAR2(1000)

The error message raised from the previous operation

ACTION

VARCHAR2(400)

The suggested action

REFRESH_DEP_MVIEWS

VARCHAR2(1)

Indicates whether the online redefinition will also refresh dependent materialized views when syncing the interim table (Y) or not (N)

See Also:

Oracle Database
Administrator’s Guide
for more information about online redefinition


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