move data from one table to another

[topgun]

16Million records
i would suggest export - import.... using table export and
table import option only.

hope this helps...

Hi,

What is the fastest way to move data from one table to another in the same schema.

like move data from table A to table B.

No fo records=16 million.

Thanks
Sam