Steps to configure a BATCHSQL mode in Oracle GoldenGate

Steps to configure a BATCHSQL mode in Oracle GoldenGate 

How to do it…

The BATCHSQL mode can be configured by adding the following parameters in the replicat
configuration file:

       REPLICAT RGGTEST1
       USERID GGATE_ADMIN@TGORTEST, PASSWORD GGATE_ADMIN
       DISCARDFILE /u01/app/ggate/dirrpt/RGGTEST1.dsc,append,MEGABYTES 500
       ASSUMETARGETDEFS
       MAP SCOTT.*, TARGET SCOTT.*;
       BATCHSQL BATCHPERQUEUE 100, OPSPERBATCH 200
  • June 14, 2016 | 15 views
  • Comments