Copy data from One table to another table
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
insert dbtab1 from table itab accepting duplicate keys.