RE: Importing MS Access to Oracle
- From: "Huascar Espinoza" <hespinoza@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Mar 2004 09:40:03 -0400
-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
En nombre de Juan Cachito Reyes Pacheco
Enviado el: Viernes 12 de Marzo de 2004 9:33
Para: oracle-l@xxxxxxxxxxxxx
Asunto: Re: Importing MS Access to Oracle
can you post please you init.ora file
----- Original Message -----
From: "Huascar Espinoza" <hespinoza@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Cc: "Mladen Gogala" <mladen@xxxxxxxxxxxxxxx>
Sent: Friday, March 12, 2004 9:18 AM
Subject: RE: Importing MS Access to Oracle
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
En nombre de Mladen Gogala
Enviado el: Jueves 11 de Marzo de 2004 15:02
Para: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
