map scott.*, target scott.*;
GGSCI (jp) 9> dblogin userid ogg,password ogg;
Successfully logged into database.
GGSCI (jp) 14> add checkpointtable ogg.checkpoint
Successfully created checkpoint table ogg.checkpoint.
GGSCI (jp) 16> add replicat rep2,exttrail /u01/app/oracle/ogg/dirdat/pt,checkpointtable ogg.checkpoint
REPLICAT added.
GGSCI (jp) 17> start rep2
Sending START request to MANAGER ...
REPLICAT REP2 starting
GGSCI (jp) 18> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP2 00:00:00 00:00:00
DML测试
源端：
SCOTT@ORCL>insert into dept values(33,'TEST','TEST1');
1 row created.
SCOTT@ORCL>commit;
Commit complete.
目标端：
SCOTT@ORCL>select * from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
33 TEST TEST1
测试成功。
注：实验中源端和目标端都已存在scott用户及相应表，所以没有数据初始化过程。