RE: Importing MS Access to Oracle

From: <David.Schmoldt_at_gazettecommunications.com>
Date: Thu, 11 Mar 2004 13:26:41 -0600
Message-ID: <A7977E8FF208D51184AD0090277CBBD805E801C5@gfc8.gfc.iowa.com>

Look into Oracle Migration Workbench. A free download on OTN.
-----Original Message-----

From: Huascar Espinoza [mailto:hespinoza_at_superele.gov.bo] Sent: Thursday, March 11, 2004 9:55 AM
To: oracle-l_at_freelists.org
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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Mar 11 2004 - 14:38:52 CST