RE: Importing MS Access to Oracle
- From: Kevin Toepke <ktoepke@xxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 14:09:37 -0500
Check out Bulk Inserts (bulk Binds)
Plus, you may want to look into the /*+ APPEND */ hint.
Kevin
-----Original Message-----
From: Huascar Espinoza [mailto:hespinoza@xxxxxxxxxxxxxxx]
Sent: Thursday, March 11, 2004 10:55 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Importing MS Access to Oracle
I have another question about Oracle performance... I want to import MS
Access to Oracle (Delphi as programming tool). But all the mechanisms are
slows. By SQL Loader the process of importing 2,000,000 registers take 2.5
hours (take in account 30 mins. to parcer the file in TEXT format). Using
SQL Server, through link tables, I get the same process in 40 mins.
What is the better and fast mechanism to import information to Oracle, from
MS Access?
Thank you!
Huascar Espinoza
Other related posts:
