####################################################################################
Method 1 – File to Replicat Keeping Note both source and target having similar structure of objects .
1. *.Create parameter file for extracting tables.
*. Run the extract which will create dumps in remote location directly
2. Create paramter file for replicate separately for each table.
####################################################################################
[oracle@ora12c1 dirprm]$ cat initload.prm
SOURCEISTABLE
USERIDALIAS oggsrc
RMTHOST ora12c1.localdomain MGRPORT 7909
RMTFILE ./dirdat/ECONOMIC_ENTITY.DAT, PURGE
TABLE ogg1.east.ECONOMIC_ENTITY;
RMTFILE ./dirdat/GDP_BY_YEAR.DAT, PURGE
TABLE ogg1.east.GDP_BY_YEAR;
[oracle@ora12c1 dirprm]$
[oracle@ora12c1 ogg_src]$ ./extract paramfile dirprm/initload.prm reportfile dirrpt/initload.rpt
[oracle@ora12c1 dirdat]$ ls -lrt
total 332
-rw-r-----. 1 oracle dba 116 Aug 7 13:59 reast.dsc
-rw-r-----. 1 oracle dba 223518 Aug 7 16:25 PP000000000
-rw-r-----. 1 oracle dba 24191 Aug 7 16:40 ECONOMIC_ENTITY.DAT
-rw-r-----. 1 oracle dba 85105 Aug 7 16:40 GDP_BY_YEAR.DAT
[oracle@ora12c1 dirdat]$
*********Replicat END
[oracle@ora12c1 ogg_trg]$ cat dirprm/loadinit.prm
SPECIALRUN
END RUNTIME
USERIDALIAS oggtrg
ASSUMETARGETDEFS
MAP OGG1.east.ECONOMIC_ENTITY, target OGG2.west.ECONOMIC_ENTITY;
[oracle@ora12c1 ogg_trg]$
[oracle@ora12c1 dirprm]$ cat loadinit1.prm
SPECIALRUN
END RUNTIME
USERIDALIAS oggtrg
ASSUMETARGETDEFS
EXTFILE ./dirdat/GDP_BY_YEAR.DAT
MAP OGG1.east.GDP_BY_YEAR, target OGG2.west.GDP_BY_YEAR;
[oracle@ora12c1 dirprm]$
[oracle@ora12c1 ogg_trg]$ ./replicat paramfile dirprm/loadinit.prm reportfile dirrpt/loadinint.rpt
[oracle@ora12c1 ogg_trg]$ ./replicat paramfile dirprm/loadinit1.prm reportfile dirrpt/loadinint1.rpt
####################################################################################
Method 2 :Direct LoadKeeping Note both source and target having similar structure of objects .
1. *.Create parameter file for extracting tables and add
*. Run the extract which will create dumps in remote location directly
2. Create paramter file for replicate separately and run replicat .
####################################################################################
GGSCI (ora12c1.localdomain) 2> view param indrload.prm
SOURCEISTABLE
USERIDALIAS oggsrc
RMTHOST ora12c1.localdomain, MGRPORT 7909
RMTFILE ./dirdat/ECONOMIC_ENTITY.DAT, PURGE
TABLE ogg1.east.ECONOMIC_ENTITY;
RMTFILE ./dirdat/GDP_BY_YEAR.DAT, PURGE
TABLE ogg1.east.GDP_BY_YEAR;
GGSCI (ora12c1.localdomain) 13> add extract indrload , SOURCEISTABLE
ERROR: EXTRACT INDRLOAD already exists.
GGSCI (ora12c1.localdomain) 3>
GGSCI (ora12c1.localdomain) 5> view param loaddr
replicat loaddr
ASSUMETARGETDEFS
USERIDALIAS oggtrg
DISCARDFILE ./dirdat/loaddr.dsc, purge
MAP OGG1.east.*, target OGG2.west.*;
GGSCI (ora12c1.localdomain) 6> add replicat loaddr, SPECIALRUN
REPLICAT added.
GGSCI (ora12c1.localdomain) 7>start loaddr