DBA Data[Home] [Help]

VIEW: SYS.DBA_SR_OBJ_STATUS

Source

View Text - Preformatted

select OWNER, NAME, TYPE, GROUP_ID, STATUS, ERROR_NUMBER,
ERROR_MESSAGE, LAST_MODIFIED_TIME
from dba_sr_obj_status_all
where current_run = 'Y' and current_group = 'Y'
View Text - HTML Formatted

SELECT OWNER
, NAME
, TYPE
, GROUP_ID
, STATUS
, ERROR_NUMBER
, ERROR_MESSAGE
, LAST_MODIFIED_TIME FROM DBA_SR_OBJ_STATUS_ALL WHERE CURRENT_RUN = 'Y'
AND CURRENT_GROUP = 'Y'