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
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
|
|
|