apply_alter Procedure
It is important to note that an Apply
process is stopped and restarted automatically when the value of
one or more of the following alter_apply procedure
parameters is changed:
-
message_handler
-
ddl_handler
-
apply_user
-
apply_tag
-
precommit_handler
To view the handlers, the dba_apply
view can be queried:
Select apply_name, ddl_handler,
precommit_handler,
message_handler from dba_apply
/
To view the DML handlers, which can number
more than one for an Apply process, the
dba_apply_dml_handlers view can be queried:
Select apply_name, user_procedure,
operation_name,
Object_owner, object_name, error_handler
from dba_apply_dml_handlers
/
The next section introduces some of the
procedures that help to handle the errors.
