This content has been marked as final. Show 9 replies
Look at http://download.oracle.com/docs/cd/E18101_01/doc.1111/e17791.pdf
for the Oracle trace table commands
Also look at
[ALLOWLOBDATATRUNCATE | NOALLOWLOBDATATRUNCATE]
[CATALOGCONNECT | NOCATALOGCONNECT]
[FETCHLOBS | NOFETCHLOBS]
[HOST <host ID>]
[LIMITROWS | NOLIMITROWS]
[SPTHREAD | NOSPTHREAD]
[SUPPRESSTRIGGERS | NOSUPPRESSTRIGGERS]
[XMLBUFSIZE <buffer size>]
Valid for Replicat for Oracle. Prevents triggers from firing
on target objects that are configured for replication with
Oracle GoldenGate. You can use this parameter for Oracle
10.2.0.5 and later patches, and for Oracle 220.127.116.11 and
later, instead of manually disabling the triggers. To use
this option, the Replicat user must be an Oracle Streams
administrator, which can be granted by invoking
The default is NOSUPPRESSTRIGGERS.
Edited by: gjilevski1 on Sep 8, 2010 10:26 AM
really this is verymuch helpful. thank you so much for your help.
Any further questions?
Thanks. One more question,
1. Is it possible to call the PL/sql procedure in GG for filtering condition? and how it will work?
whether everytime this procedure run against the filtering tables?
2. Will there be any delay of joining tables in GG filtering?
Is there any documents available , can you please provide me,?
Thanks in Advance.
Use SQLEXEC to execute a SQL stored procedure or query from within a MAP statement
during Oracle GoldenGate processing. SQLEXEC enables Oracle GoldenGate to communicate
directly with the database to perform any function supported by the database. The
database function can be part of the synchronization process, such as retrieving values for
column conversion, or it can be independent of extracting or replicating data.
Edited by: gjilevski1 on Sep 9, 2010 12:06 PM
Thank you so much
as per the pdf link which is you have provided earlier,
The following data types are not supported by GG SQLEXEC,
Can you please confirm ,
Will GG not filter table containing these datatypes or will it no filter only on columns of these datatypes.
Thanks in Advance.
You cannot use those data types. That is, you can exclude the data type and then use sqlexec.
Is there any document available for goldengate with RAC environment?