| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_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.
-- 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:15:58 CST
 |
 |