VIEW: SYS.DBA_REDEFINITION_ERRORS

Source

View Text - Preformatted

select decode(obj_type, 1, 'TABLE',
                        2, 'INDEX',
                        3, 'CONSTRAINT',
                        4, 'TRIGGER',
                        6, 'NESTED TABLE',
                        7, 'PARTITION',
                        10, 'MV LOG',
                        'UNKNOWN'),
       decode(ou.type#, 2, ou.ext_username, ou.name), obj_name,
       bt_owner, bt_name, ddl_txt,
       decode(ou.type#, 2,
              (select name from sys.obj$ o where ou.spare2 = o.obj#),
              decode(obj_type, 4, 'ORA$BASE', NULL)),
       e.err_no, e.err_txt
from sys.redef_dep_error$ e, sys.user$ ou
where e.obj_owner = ou.name

View Text - HTML Formatted

SELECT DECODE(OBJ_TYPE
, 1
, 'TABLE'
, 2
, 'INDEX'
, 3
, 'CONSTRAINT'
, 4
, 'TRIGGER'
, 6
, 'NESTED TABLE'
, 7
, 'PARTITION'
, 10
, 'MV LOG'
, 'UNKNOWN')
, DECODE(OU.TYPE#
, 2
, OU.EXT_USERNAME
, OU.NAME)
, OBJ_NAME
, BT_OWNER
, BT_NAME
, DDL_TXT
, DECODE(OU.TYPE#
, 2
, (SELECT NAME
FROM SYS.OBJ$ O
WHERE OU.SPARE2 = O.OBJ#)
, DECODE(OBJ_TYPE
, 4
, 'ORA$BASE'
, NULL))
, E.ERR_NO
, E.ERR_TXT FROM SYS.REDEF_DEP_ERROR$ E
, SYS.USER$ OU WHERE E.OBJ_OWNER = OU.NAME