Oracle教程 2023-02-24

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`)