05-01-2006 7:16 PM
Hi Friends,
I need to copy data from one table to another table for backup , there is around 6 million records .
Please advice the fastest way to move the data into another table.
this is the code which i am planing to write . is there any other faster way to update the code.
select * from dbtab
into table itab
where .....
insert dbtab1 from table itab accepting duplicate keys.
Thanks
Venkat
05-01-2006 7:19 PM
I am not sure if the memory will be able to handle so many records in one shot. You might want to break into smaller chunks and do the same.
Regards,
Ravi
Note - Please mark the helpful answers
05-01-2006 7:31 PM
Hi Venkat,
You may want to use <b>OPEN CURSOR</b>, <b>FETCH</b> and <b>CLOSE CURSOR</b> statements.
Hope this will help.
Regards,
Ferry Lianto
05-01-2006 7:33 PM