VIEW: SYS.DBA_REDEFINITION_OBJECTS

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,
       decode(iu.type#, 2, iu.ext_username, iu.name), int_obj_name,
       decode(ou.type#, 2,
              (select name from sys.obj$ o where ou.spare2 = o.obj#),
              decode(obj_type, 4, 'ORA$BASE', NULL))
from sys.redef_object$ ro, sys.user$ ou, sys.user$ iu
where ro.obj_owner = ou.name
and ro.int_obj_owner = iu.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
, DECODE(IU.TYPE#
, 2
, IU.EXT_USERNAME
, IU.NAME)
, INT_OBJ_NAME
, DECODE(OU.TYPE#
, 2
, (SELECT NAME
FROM SYS.OBJ$ O
WHERE OU.SPARE2 = O.OBJ#)
, DECODE(OBJ_TYPE
, 4
, 'ORA$BASE'
, NULL)) FROM SYS.REDEF_OBJECT$ RO
, SYS.USER$ OU
, SYS.USER$ IU WHERE RO.OBJ_OWNER = OU.NAME AND RO.INT_OBJ_OWNER = IU.NAME