RE: Importing MS Access to Oracle

From: Huascar Espinoza <hespinoza_at_superele.gov.bo>
Date: Thu, 11 Mar 2004 16:14:09 -0400
Message-ID: <B2DC72F71B99474B8CCA0C3611AAC2A814867F@correo.super.gov.bo>

I have the same problem with link tables, process is so slow. The same process with SQL Loader (2.5 hours) take 4 hours with link tables.:-(

Thank you,

Huascar

-----Mensaje original-----

De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de Goulet, Dick
Enviado el: Jueves 11 de Marzo de 2004 15:04 Para: oracle-l_at_freelists.org
Asunto: RE: Importing MS Access to Oracle

You can do the same thing with linked tables in Oracle. Just make sure you pre-create the tables otherwise Access can do some non standard and funny things.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----

From: Huascar Espinoza [mailto:hespinoza_at_superele.gov.bo] Sent: Thursday, March 11, 2004 10:54 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 - 16:56:43 CST