Transfer data to Oracle

[wichtel]

Hello

I'm currently using Access to transfer huge data tables to Oracle (ODBC). The problem is that this takes a very long time. Do you know a better tool to transfer .csv to Oracle?

Thanks,
Tom

 

[Tranman]

Don't know of any better tools. I sometimes transfer several hundreds of thousands of rows from Access to Oracle.

Here are a couple of tricks I use:
What I do is, in my Oracle tables, drop all of the indexes, then re-create the them after the data is in. You can create an Oracle procedure to do the dropping and creating, and it will accelerate the transfer process considerably.

Also, in using ODBC, I always use the Microsoft ODBC Driver for Oracle, instead of the Oracle ODBC driver, because it runs somewhat faster.

Good Luck,
Tranman



"Adam was not alone in the Garden of Eden, however,...much is due to Eve, the first woman, and Satan, the first consultant." Mark Twain