Subscriber Count

    459

Subscribe to Posts by Email

Pages

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