Inserting more than million records
NordikMay 29 2011 — edited May 30 2011Hi,
I need to insert more than 2 million records from one table to another (This needs to be done for few tables so writting a pl/sql script and using dynamic SQL for insert).I am planning to use direct path insert i.e. insert /* + Append */ in my code. Can any one tell me some better way of doing it.
Nordick