Example 3 : Configure the Extract / Replicat for Initial Load

In this example, we create the table on source side called myobj from dba_objects and need to create a initial load using one time process.

On Source	Steps	On Target	Steps
Configure Extract Process	cd /data/ggate ./ggsci ADD EXTRACT ext1, SOURCEISTABLE EDIT PARAMS ext1 ### Copy following to the extract param file ### EXTRACT ext1 USERID ggs_owner, PASSWORD ggs_owner RMTHOST 192.168.56.109, MGRPORT 7809 RMTTASK replicat, GROUP rep1 TABLE test.myobj;	Configure Replicat Process	cd /data/ggate ./ggsci ADD replicat rep1, specialrun EDIT PARAMS rep1 ### Copy following to the extract param file### REPLICAT rep1 USERID ggs_owner, PASSWORD ggs_owner ASSUMETARGETDEFS MAP test.myobj, TARGET test.myobj;
Start Extract Process	./ggsci start extract ext1 info all	Start Replicat Process	./ggsci start replicat rep1 info all
Check the Data	select count(*) from test.myobj;	Check the Data	select count(*) from test.myobj;
View Report	./ggsci info extract ext1, detail	View Report	./ggsci info replicat rep1, detail

All about Database Administration, Tips & Tricks