DBA_REDEFINITION

5.262 DBA_REDEFINITION_STATUS

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 This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`BASE_OBJECT_TYPE`	`VARCHAR2(9)`		Type of the base object of the redefinition object This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`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 This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`ACTION`	`VARCHAR2(400)`		The suggested action This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).
`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`) This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).