Hi,

I have two tables weblog@stats and weblog@stats2. I am currently connected to the stats2 database instance.

Weblog@stats - 5.4 million rows
Weblog@stats2 - 4.68 million rows

I want to get both tables in sync. I am using the following code. Is there a more efficient way for me to achieve this?

Thanks.


declare
cursor c1 is
select * from weblog@stats
where seqnum not in (select seqnum from weblog);
begin
for rec in c1 loop
insert into weblog(URL, UNIVERSITY, SERVER_NAME, SEQNUM)
values(rec.URL, rec.UNIVERSITY , rec.SERVER_NAME , rec.SEQNUM);
commit;
end loop;
end;
/