-
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;
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|