DBA_REDEFINITION_ERRORS

DBA_REDEFINITION_ERRORS is an online redefinition view. It displays the dependent objects for which errors were raised while attempting to create similar objects on the interim table of the redefinition.

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
DDL_TXT CLOB   DDL used to create the corresponding interim redefinition object
EDITION_NAME VARCHAR2(128)   Reserved for future use
ERR_NO NUMBER(38)   Oracle error number corresponding to this error
ERR_TXT VARCHAR2(1000)   Oracle error text corresponding to this error

See Also: Oracle AI Database Administrator’s Guide for more information about online redefinition