Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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
PREV_OPERATION VARCHAR2(128) NOT NULL The previous redefinition operation attempted:
  • 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