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.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
