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

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.