Importing MS Access to Oracle

From: Huascar Espinoza <hespinoza_at_superele.gov.bo>
Date: Thu, 11 Mar 2004 11:54:30 -0400
Message-ID: <B2DC72F71B99474B8CCA0C3611AAC2A8148622@correo.super.gov.bo>

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 - 13:13:01 CST