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
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
|
|
|