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!

Bulk insert Vs Insert

jaggyamNov 14 2007 — edited Nov 14 2007

Hi all,

I am inserting some 11 million records in a table using 4 source tables. Which one will be faster, insert into ... select.... or bulk insert with limit.

thanks in advance

Regards,
Jaggyam

Message was edited by:
jaggyam

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 12 2007

Added on Nov 14 2007

5 comments

972 views