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_PARTITION_NAME

VARCHAR2(128)

NOT NULL

Name of the base partition 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

OPERATION1

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


See Also:

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

1

This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).