skip to main
|
skip to sidebar
All about Oracle database
Thursday, December 11, 2008
Unset streams DML handler
To unset DML handler in a streams environment, simply point "user_procedure" to NULL.
Eg.
BEGIN DBMS_APPLY_ADM.SET_DML_HANDLER(
object_name => '
',
object_type => 'TABLE',
operation_name => 'INSERT',
error_handler => false,
user_procedure => NULL ,
apply_database_link => NULL,
apply_name => NULL);
END;
/
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Archive
▼
2008
(9)
►
November
(7)
▼
December
(2)
How to re-synchronize the streams replicated objec...
Unset streams DML handler
►
2009
(7)
►
January
(3)
►
February
(1)
►
April
(1)
►
July
(1)
►
August
(1)
►
2010
(1)
►
February
(1)
►
2015
(1)
►
May
(1)
My Favourite Oracle Books
Expert Oracle Database Architecture
OCA: Oracle 10g Administration I Study Guide
OCP: Oracle 10g Administration II Study Guide
Oracle 10g RAC Grid, Services & Clustering
Oracle Database 10g Performance Tuning Tips & Techniques
Pro Oracle Database 10g RAC on Linux
RMAN Recipes for Oracle Database 11g
My Favourite Oracle References
Ari Kaplan's Oracle Tips
Ask The Oracle
ask TOM Oracle
Burleson Consulting
Dan Norris
DBA Village
DBAsupport
dbazine
Evergreen Database Technologies
Jeffrey Hunter's Oracle
Oracle FAQ
Oracle Forum
Oracle Performance
ORACLE_BASE
Steve Karam - The Oracle Alchemist
About Me
Eric Choong
ORACLE Certified Professional (Oracle Database 10g), SUN Certified System Administrator (Solaris 10)
View my complete profile
No comments:
Post a Comment