Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
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
View PDF

DBA_REDEFINITION_OBJECTS

DBA_REDEFINITION_OBJECTS is an online redefinition view and 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(30) NOT NULL Name of the redefinition object
BASE_TABLE_OWNER VARCHAR2(30)   Owner of the base table of the redefinition object
BASE_TABLE_NAME VARCHAR2(30)   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(30)   Name of the corresponding interim redefinition object
EDITION_NAME VARCHAR2(30)   Reserved for future use