oracle+GoldenGate学习笔记 下载本文

GGSCI> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EXT1 00:00:00 00:00:07 REPLICAT RUNNING REP1 00:00:00 00:00:08

4. 测试同步

使用sqlplus执行SQL语句:

create table ggs.tb1 (a number, CONSTRAINT pk1 PRIMARY KEY (a))

create table ggt.tb1 (a number, CONSTRAINT pk1 PRIMARY KEY (a))

然后运行:

insert into ggs.tb1 values (1); commit;

看看是否同步到了ggt.tb1了?

; 26

;