Why would he need to do that? On 03/12/2004 08:32:57 AM, Juan Cachito Reyes Pacheco wrote: > 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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- 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 -----------------------------------------------------------------