 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 6 -
Apply Handlers
Setting the Pre-Commit Handler for an Apply
Process
For example, the following procedure sets the
pre-commit handler for an Apply process named LN_APPLY in the
record_precommit procedure in the STRMADM schema:
BEGIN
DBMS_APPLY_ADM.ALTER_APPLY(
apply_name => 'ln4_apply',
precommit_handler =>
'strmadm.record_precommit');
END;
/
The pre-commit handler for an Apply process can
be removed by setting the remove_precommit_handler parameter
to TRUE in the alter_apply procedure in the dbms_apply_adm
package.
For example, the following procedure removes
the pre-commit handler from an Apply process named LN4_APPLY:
BEGIN
DBMS_APPLY_ADM.ALTER_APPLY(
apply_name =>
'ln4_apply',
remove_precommit_handler => true);
END;
/
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
|
|
|
Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized. |
|
|
