Copy data from One table to another table

[Former Member]

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]

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]

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]

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

[Former Member]

Check

Rob