SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Improve Performance of INSERT

889505Mar 11 2012 — edited Mar 11 2012

Hi..
I have to insert nearly 5 million records to a table. These records should be inserted to the table after doing some calculations. I got this data as into cursor For loop and then inserted to the table (after doing necessary calculations). It was fast in the start. But it becomes very slow later. Does any body knows a faster way to do this?

Note: version 9i / table is in nologing mode

Thanks
vish

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2012

Added on Mar 11 2012

6 comments

446 views