Text Import and ODBC Import Speed

[Covina]

Is there a way speed up the text import and ODBC import? I do import some legacy MS Access db files a lot. Even with no extra sql formatting overhead it takes about 1.5 hrs for a million row import to Oracle. Am I getting the best out of it or am I missing something.

Thanks

 

[Marco Kalter]

That is about 200 records per second. This includes reading the data, converting it, and writing it to the database (presumably over a network). The importers do not use Array DML or Direct Path Loading, so I think this may be about the the maximum performance you can achieve.

 

[NK]

I don't mean to digress, but I get about 800 rows/sec importing .csv files using the Text Importer tool.