DBA Data[Home] [Help]

VIEW: SYS.DBA_REDEFINITION_STATUS

Source

View Text - Preformatted

select rs.redef_id, ro.bt_owner, ro.bt_name,  rs.obj_name,
       ro.int_obj_owner, ro.int_obj_name,
       rs.prev_operation, rs.status, rs.restartable
from sys.redef_status$ rs LEFT OUTER JOIN sys.redef_object$ ro
ON rs.redef_id = ro.redef_id AND rs.obj_name = ro.obj_name
View Text - HTML Formatted

SELECT RS.REDEF_ID
, RO.BT_OWNER
, RO.BT_NAME
, RS.OBJ_NAME
, RO.INT_OBJ_OWNER
, RO.INT_OBJ_NAME
, RS.PREV_OPERATION
, RS.STATUS
, RS.RESTARTABLE FROM SYS.REDEF_STATUS$ RS LEFT OUTER JOIN SYS.REDEF_OBJECT$ RO ON RS.REDEF_ID = RO.REDEF_ID
AND RS.OBJ_NAME = RO.OBJ_NAME