Extract & Replicat process tagged posts

Oracle Golden Gate Initial Data Load between Source and Target

by Snehashish Ghosh


 OS – Windows 7 32 bit

Oracle Database 11g R2

OGG ogg112101

Download OGG from oracle using the following link:


We shall replicate data from one schema of a oracle database to another schema in the same oracle database.

Source schema name – sender

Destination schema name – receiver

 Install Oracle Golden Gate

1. Unzip the Oracle Golden Gate installation file ogg112101_ggs_Windows_x86_ora11g_32bit.zip to d:\ogg folder.


2.  Open a command prompt,go to golden gate installation folder and run create subdirs.


 Oracle Golden Gate Command Interpreter for Oracle

Version OGGCORE_11.

Windows (optimized), Oracle 11g on Apr...

Read More