9 Replies Latest reply: Sep 15, 2010 4:20 AM by Annamalai A RSS

    GOLDENGATE WITH TRIGGER

    Annamalai A
      Hi,

      Can you please help me on this

      How to avoid firing source triggers on target system ?

      also how to avoid target system triggers on source system?(like vice versa?)


      Is it possible in golden gate?

      Thanks in Advance
        • 1. Re: GOLDENGATE WITH TRIGGER
          gjilevski1
          Hi,

          Look at http://download.oracle.com/docs/cd/E18101_01/doc.1111/e17791.pdf

          for the Oracle trace table commands

          Also look at

          DBOPTIONS
          [ALLOWLOBDATATRUNCATE | NOALLOWLOBDATATRUNCATE]
          [ALLOWUNUSEDCOLUMN]
          [CATALOGCONNECT | NOCATALOGCONNECT]
          [CONNECTIONPORT <port>]
          [DEFERREFCONST]
          [DISABLELOBCACHING]
          [EMPTYLOBSTRING ‘<string>’]
          [FETCHBATCHSIZE <num_recs>]
          [FETCHLOBS | NOFETCHLOBS]
          [HOST <host ID>]
          [LIMITROWS | NOLIMITROWS]
          [LOBBUFSIZE]
          [LOBWRITESIZE <size>]
          [SHOWINFOMESSAGES]
          [SHOWWARNINGS]
          [SPTHREAD | NOSPTHREAD]
          [SUPPRESSTRIGGERS | NOSUPPRESSTRIGGERS]
          [TDSPACKETSIZE <bytes>]
          [TRUSTEDCONNECTION]
          [USEODBC]
          [USEREPLICATIONUSER]
          [XMLBUFSIZE <buffer size>]



          SUPPRESSTRIGGERS |
          NOSUPPRESSTRIGGERS
          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 11.2.0.2 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
          dbms_goldengate_auth.grant_admin_privilege.
          The default is NOSUPPRESSTRIGGERS.

          Regards,

          Edited by: gjilevski1 on Sep 8, 2010 10:26 AM
          • 2. Re: GOLDENGATE WITH TRIGGER
            Annamalai A
            Hi

            really this is verymuch helpful. thank you so much for your help.
            • 3. Re: GOLDENGATE WITH TRIGGER
              gjilevski1
              Hi,

              Any further questions?

              Regards,
              • 4. Re: GOLDENGATE WITH TRIGGER
                Annamalai A
                Hi,

                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.
                • 5. Re: GOLDENGATE WITH TRIGGER
                  gjilevski1
                  Hi,

                  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.

                  http://download.oracle.com/docs/cd/E18101_01/index.htm

                  Regards,

                  Edited by: gjilevski1 on Sep 9, 2010 12:06 PM
                  • 6. Re: GOLDENGATE WITH TRIGGER
                    Annamalai A
                    Thank you so much
                    • 7. Re: GOLDENGATE WITH TRIGGER
                      Annamalai A
                      Hi ,

                      as per the pdf link which is you have provided earlier,

                      The following data types are not supported by GG SQLEXEC,

                      BFILE
                      BLOB
                      CFILE
                      CLOB
                      NCLOB
                      NTY


                      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.
                      • 8. Re: GOLDENGATE WITH TRIGGER
                        gjilevski1
                        Hi,

                        You cannot use those data types. That is, you can exclude the data type and then use sqlexec.

                        Regards,
                        • 9. Re: GOLDENGATE WITH TRIGGER
                          Annamalai A
                          Hi,

                          Is there any document available for goldengate with RAC environment?

                          Thanks