VIEW: SYS.DBA_APPLY_DML_HANDLERS

Source

View Text - Preformatted

select sname, oname,
       decode(do.apply_operation, 0, 'DEFAULT',
                                  1, 'INSERT',
                                  2, 'UPDATE',
                                  3, 'DELETE',
                                  4, 'LOB_UPDATE',
                                  5, 'ASSEMBLE_LOBS', 'UNKNOWN'),
       do.user_apply_procedure,
       do.error_handler, o.linkname, do.apply_name, do.assemble_lobs,
       do.handler_name,
       case when user_apply_procedure is null and handler_name is not null
            then 'STMT HANDLER'
            when user_apply_procedure is not null and handler_name is null
            then decode(do.error_handler, 'Y', 'ERROR HANDLER', 'PROCEDURE HANDLER')
            else 'UNKNOWN'
       end,
       decode(do.set_by,           NULL,'USER',
                                      1,'GOLDENGATE')
  from sys.obj$ o, apply$_dest_obj_ops do
 where do.object_number = o.obj# (+)

View Text - HTML Formatted

SELECT SNAME
, ONAME
, DECODE(DO.APPLY_OPERATION
, 0
, 'DEFAULT'
, 1
, 'INSERT'
, 2
, 'UPDATE'
, 3
, 'DELETE'
, 4
, 'LOB_UPDATE'
, 5
, 'ASSEMBLE_LOBS'
, 'UNKNOWN')
, DO.USER_APPLY_PROCEDURE
, DO.ERROR_HANDLER
, O.LINKNAME
, DO.APPLY_NAME
, DO.ASSEMBLE_LOBS
, DO.HANDLER_NAME
, CASE WHEN USER_APPLY_PROCEDURE IS NULL
AND HANDLER_NAME IS NOT NULL THEN 'STMT HANDLER' WHEN USER_APPLY_PROCEDURE IS NOT NULL
AND HANDLER_NAME IS NULL THEN DECODE(DO.ERROR_HANDLER
, 'Y'
, 'ERROR HANDLER'
, 'PROCEDURE HANDLER') ELSE 'UNKNOWN' END
, DECODE(DO.SET_BY
, NULL
, 'USER'
, 1
, 'GOLDENGATE')
FROM SYS.OBJ$ O
, APPLY$_DEST_OBJ_OPS DO
WHERE DO.OBJECT_NUMBER = O.OBJ# (+)