Both Parameter File Source and Target Part 5

Data Pump Replication Both Parameter Files (Source and Target)

---------- SOURCE SYSTEM -------------

GGSCI (orcldb) 35> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     DPUMP       00:00:00      00:00:01

EXTRACT     RUNNING     EXT1        00:00:00      00:00:02

GGSCI (orcldb) 36> view params mgr

PORT 7809

USERID ggs_admin, PASSWORD ggs_admin

PURGEOLDEXTRACTS /u01/app/gg/dirdat/*, USECHECKPOINTS MINKEEPHOURS 3

GGSCI (orcldb) 37> view params ext1

EXTRACT ext1

USERID ggs_admin, PASSWORD ggs_admin

EXTTRAIL /u01/app/gg/dirdat/lt

DDL INCLUDE MAPPED            # DDL REPLICATION PURPOSE

TABLE SCOTT.*;                          # Complete Scott Schema replicate every object

GGSCI (orcldb) 38> view params dpump

EXTRACT dpump

USERID ggs_admin, PASSWORD ggs_admin

RMTHOST OELDB, MGRPORT 7809

RMTTRAIL /u01/app/gg/dirdat/rt

PASSTHRU

TABLE SCOTT.*;

------------ TARGET SYSTEM PARAMETER ------------

GGSCI (oeldb) 102> view params mgr

PORT 7809

USERID ggs_admin, PASSWORD ggs_admin

PURGEOLDEXTRACTS /u01/app/gg/dirdat/*, USECHECKPOINTS MINKEEPHOURS 3

GGSCI (oeldb) 103> view params rep1

REPLICAT rep1

ASSUMETARGETDEFS

USERID ggs_admin, PASSWORD ggs_admin

MAP SCOTT.*, TARGET SCOTT.*;