RE: Importing MS Access to Oracle

From: Huascar Espinoza <hespinoza_at_superele.gov.bo>
Date: Fri, 12 Mar 2004 09:34:24 -0400
Message-ID: <B2DC72F71B99474B8CCA0C3611AAC2A81486E5@correo.super.gov.bo>

5 simple indexes. When we changed to 9 simple indexes and one 5-field-index (to increase performance of queries), the importation increase the time.

Thanks,

-----Mensaje original-----
De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de Ron Rogers
Enviado el: Viernes 12 de Marzo de 2004 9:28 Para: oracle-l_at_freelists.org
Asunto: RE: Importing MS Access to Oracle

How many indexes do you have on the table columns? Ron

>>> hespinoza_at_superele.gov.bo 03/12/2004 8:18:44 AM >>>

No Blobs, No Longs, No BFILE, only VARIANT, FLOAT AND INTEGER (14 fields), direct load. Pentium IV, 2,5 MHz. Then... What is the problem?

Thank you,

Huascar

-----Mensaje original-----
De: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
En nombre de Mladen Gogala
Enviado el: Jueves 11 de Marzo de 2004 15:02 Para: oracle-l_at_freelists.org
Asunto: Re: Importing MS Access to Oracle

On 03/11/2004 10:54:30 AM, Huascar Espinoza wrote:
> 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
>

2.5 million records takes 2.5 hours? Man, you're doing something seriously wrong.
How many MEMO fields do you have? What are you loading them into?

Blobs?
Longs?
BFILE? As for SQL*Loader, if you were doing parallel and direct load

into a NOLOGGING
table, and if the stuff you were loading consisted of short numeric/textual fields,
the whole thing would be loaded in less then 10 minutes on a 400 MHZ PC
using
the sorry excuse for an operating system, produced near Seattle, WA.

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 
-----------------------------------------------------------------
----------------------------------------------------------------
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 
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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 Fri Mar 12 2004 - 07:30:25 CST