Oracle教程 2023-04-03

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

Oracle视图DBA_REDEFINITION_OBJECTS显示所有支持重新定义的对象，以及每个重定义操作的状态，如未完成、正在重新定义或已完成。这个视图的用途在于查看表的重新定义状态，或者从中找出正在进行重新定义的表或对象。

使用方法：

1. 查看所有正在重新定义的对象：

SELECT * FROM DBA_REDEFINITION_OBJECTS WHERE STATUS = ‘IN PROGRESS’;

2. 查看某个表的重新定义状态：

SELECT * FROM DBA_REDEFINITION_OBJECTS WHERE OWNER = ” and OBJECT_NAME = ‘

‘;

DBA_REDEFINITION_OBJECTS is an online redefinition view. It displays the objects involved in the current redefinitions.

Column	Datatype	NULL	Description
`OBJECT_TYPE`	`VARCHAR2(12)`		Type of the redefinition object: `TABLE` `INDEX` `CONSTRAINT` `TRIGGER` `NESTED TABLE` `PARTITION` `MV LOG`
`OBJECT_OWNER`	`VARCHAR2(4000)`		Owner of the redefinition object
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of 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
`INTERIM_OBJECT_OWNER`	`VARCHAR2(4000)`		Owner of the corresponding interim redefinition object
`INTERIM_OBJECT_NAME`	`VARCHAR2(128)`		Name of the corresponding interim redefinition object
`EDITION_NAME`	`VARCHAR2(128)`		Reserved for future use