DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, June 14, 2016

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

No comments: