VIEW: SYS.DBA_SR_OBJ_STATUS_ALL

Source

View Text - Preformatted

select u1.name owner,
       o1.name name,
       decode(o1.type#,
              2, 'TABLE',
              42, 'MVIEW') type,
       st.group_id,
       decode(st.status,
              0, 'NOT PROCESSED',
              1, 'COMPLETE',
              4, 'ABORT') status,
       decode(st.cur_run_flag,
              0, 'N',
              1, 'Y')  current_run,
       decode(s1.current_group_flag,
              0, 'N',
              1, 'Y')  current_group,
       error_number,                        /* error number if any */
       error_message,                       /* error message if any */
       last_modified_time                   /* time of last refresh */
from sys.obj$ o1, sys.syncref$_objects s1, sys.syncref$_object_status st,
  sys.user$ u1
where o1.obj# = s1.obj# and s1.obj# = st.obj#
      and o1.type# = s1.object_type_flag and o1.owner# = u1.user#
      and s1.group_id = st.group_id

View Text - HTML Formatted

SELECT U1.NAME OWNER
, O1.NAME NAME
, DECODE(O1.TYPE#
, 2
, 'TABLE'
, 42
, 'MVIEW') TYPE
, ST.GROUP_ID
, DECODE(ST.STATUS
, 0
, 'NOT PROCESSED'
, 1
, 'COMPLETE'
, 4
, 'ABORT') STATUS
, DECODE(ST.CUR_RUN_FLAG
, 0
, 'N'
, 1
, 'Y') CURRENT_RUN
, DECODE(S1.CURRENT_GROUP_FLAG
, 0
, 'N'
, 1
, 'Y') CURRENT_GROUP
, ERROR_NUMBER
, /* ERROR NUMBER IF ANY */ ERROR_MESSAGE
, /* ERROR MESSAGE IF ANY */ LAST_MODIFIED_TIME /* TIME OF LAST REFRESH */ FROM SYS.OBJ$ O1
, SYS.SYNCREF$_OBJECTS S1
, SYS.SYNCREF$_OBJECT_STATUS ST
, SYS.USER$ U1 WHERE O1.OBJ# = S1.OBJ#
AND S1.OBJ# = ST.OBJ#
AND O1.TYPE# = S1.OBJECT_TYPE_FLAG
AND O1.OWNER# = U1.USER#
AND S1.GROUP_ID = ST.GROUP_ID