Importing from a csv file

[rpwils2]

What is the fastest way to import data from a csv file into oracle 11g? We are talking about a lot of data ~ 50 gigs

 

[Thargy]

external tables - they are easier and faster than sql loader, and tons easier to use. Also you don't need to use staging tables, and can perform SQL manipulation on the data, as it's loaded.

Regards

T

 

[rpwils2]

Thanks for the reply. Is there a performance difference between temp table and external tables? Are there any tips to loading thousands of quickly from csv?

 

[Thargy]

A temporary table is just that - temporary. It exists inside the db. As their name suggests, external tables don't.

I've just provided you with tips on how to load quickly from CSV. Now it's up to you to read the documentation and develope your own solution for your own needs.

If you want further advice, at least show willing, and post what you've done thus far.

Regards

T