DBA Data[Home] [Help]

VIEW: SYS.ALL_APPLY_DML_HANDLERS

Source

View Text - Preformatted

select h.object_owner, h.object_name, h.operation_name,
       h.user_procedure, h.error_handler, h.apply_database_link, h.apply_name,
       h.assemble_lobs, h.set_by
  from all_tables o, dba_apply_dml_handlers h
 where h.object_owner = o.owner
   and h.object_name = o.table_name
View Text - HTML Formatted

SELECT H.OBJECT_OWNER
, H.OBJECT_NAME
, H.OPERATION_NAME
, H.USER_PROCEDURE
, H.ERROR_HANDLER
, H.APPLY_DATABASE_LINK
, H.APPLY_NAME
, H.ASSEMBLE_LOBS
, H.SET_BY
FROM ALL_TABLES O
, DBA_APPLY_DML_HANDLERS H
WHERE H.OBJECT_OWNER = O.OWNER
AND H.OBJECT_NAME = O.TABLE_NAME