Oracle GoldenGate suppresstriggers
For replication involving Oracle GoldenGate, a
suppresstriggers option has been added to the dboptions
Replicat parameter. The purpose of the suppresstriggers
option is simply to prevent triggers from firing on objects targeted
for replication.
For specific versions of Oracle using Oracle GoldenGate version
11.1 and higher, the suppresstriggers option relieves the
DBA of having to manually disable triggers and constraints
individually.
Replicat will disable triggers during its session with the
suppresstriggers option for the following Oracle versions:
- Oracle 10g R2 releases 10.2.0.5 and later patches
- Oracle 11g R2 releases 11.2.0.2 and higher
It is important to note that the suppresstriggers option
is NOT available in Oracle 11g R1.
The default setting for suppresstriggers is OFF or
nosuppresstriggers.
Using the suppresstriggers option requires that the
Replicat user be an Oracle Streams administrator. The
following version-specific grants must be invoked:
- Oracle 10.2.0.5 and later patches:
dbms_streams_auth.grant_admin_privilege
- Oracle 11.2.0.2 and higher
dbms_goldengate_auth.grant_admin_privilege
If suppresstriggers is not working for you, verify that
you are using Oracle GoldenGate 11.1 or higher and are not using
Oracle 11g R1 database.
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
