topic Re: Copy data from One table to another table in Application Development and Automation Discussions

Copy data from One table to another table

Former Member — Mon, 01 May 2006 18:16:03 GMT

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

Former Member — Mon, 01 May 2006 18:19:33 GMT

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

Former Member — Mon, 01 May 2006 18:31:42 GMT

Hi Venkat,

You may want to use OPEN CURSOR, FETCH and CLOSE CURSOR statements.

Hope this will help.

Regards,

Ferry Lianto

Former Member — Mon, 01 May 2006 18:33:51 GMT

Check

Rob