GoldenGate Test SQL


insert into GGDEVUSR.ggtest01
(ID,HOST_NAME)
values (1,'TESTING INSERT');

commit;

select * from GGDEVUSR.ggtest01;

create table GGDEVUSR.test_mrc01 as (select * from dba_tables);

insert into ggdevusr.test_mrc01 (select * from dba_tables);

insert into ggdevusr.test_mrc01 (select * from ggdevusr.test_mrc01 );

delete from ggdevusr.test_mrc01 where rownum < 50000;

select count(*) from ggdevusr.test_mrc01;