DBA Data[Home] [Help]

VIEW: SYS.ALL_APPLY_REPERROR_HANDLERS

Source

View Text - Preformatted

select rh."APPLY_NAME",rh."OBJECT_OWNER",rh."OBJECT_NAME",rh."SOURCE_OBJECT_OWNER",rh."SOURCE_OBJECT_NAME",rh."ERROR_NUMBER",rh."METHOD",rh."MAX_RETRIES",rh."DELAY_CSECS",rh."SET_BY"
from DBA_APPLY_REPERROR_HANDLERS rh, ALL_APPLY a, all_tables t
where rh.apply_name = a.apply_name and rh.object_owner = t.owner
      and rh.object_name = t.table_name
View Text - HTML Formatted

SELECT RH."APPLY_NAME"
, RH."OBJECT_OWNER"
, RH."OBJECT_NAME"
, RH."SOURCE_OBJECT_OWNER"
, RH."SOURCE_OBJECT_NAME"
, RH."ERROR_NUMBER"
, RH."METHOD"
, RH."MAX_RETRIES"
, RH."DELAY_CSECS"
, RH."SET_BY" FROM DBA_APPLY_REPERROR_HANDLERS RH
, ALL_APPLY A
, ALL_TABLES T WHERE RH.APPLY_NAME = A.APPLY_NAME
AND RH.OBJECT_OWNER = T.OWNER
AND RH.OBJECT_NAME = T.TABLE_NAME