Skip to Main Content
Forums

Database Software

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!

fastest way to load csv into oracle BE table

845109Nov 2 2012 — edited Nov 2 2012
I have csv file which is having 10 million records in it . what is the fastest approach to load this data to oracle BE table .

I am using Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options .

csv format
first_name,last_name,occupation,address

above all the fields are of varchar data type.

I have tried to use external table while inserting its taking too much time .


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2012
Added on Nov 2 2012
#database-key-features, #export-import-sql-loader-external-tables
5 comments
7,527 views