From oracle-l-bounce@freelists.org Thu Mar 11 15:29:18 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2BLTIU20556 for ; Thu, 11 Mar 2004 15:29:18 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2BLTEo20543 for ; Thu, 11 Mar 2004 15:29:14 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B20AB395C4B; Thu, 11 Mar 2004 15:04:40 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 15:03:33 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from wilmail.wilnet (unknown [208.235.71.25]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EF4623961E6 for ; Thu, 11 Mar 2004 14:04:33 -0500 (EST) Received: by wilmail.wilnet with Internet Mail Service (5.5.2656.59) id ; Thu, 11 Mar 2004 14:09:38 -0500 Message-ID: <524A8924345BD411B65600508B9A8B6505F17B26@wilmail.wilnet> From: Kevin Toepke To: "'oracle-l@freelists.org'" Subject: RE: Importing MS Access to Oracle Date: Thu, 11 Mar 2004 14:09:37 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4079C.656D6FE0" X-archive-position: 531 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ktoepke@rlcarriers.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C4079C.656D6FE0 Content-Type: text/plain Check out Bulk Inserts (bulk Binds) Plus, you may want to look into the /*+ APPEND */ hint. Kevin -----Original Message----- From: Huascar Espinoza [mailto:hespinoza@superele.gov.bo] Sent: Thursday, March 11, 2004 10:55 AM To: oracle-l@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 ------_=_NextPart_001_01C4079C.656D6FE0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Message
Check=20 out Bulk Inserts (bulk Binds)
 
Plus,=20 you may want to look into the /*+ APPEND */=20 hint.
 
Kevin
-----Original Message-----
From: = Huascar Espinoza=20 [mailto:hespinoza@superele.gov.bo]
Sent: Thursday, March = 11, 2004=20 10:55 AM
To: oracle-l@freelists.org
Subject: = Importing MS=20 Access to Oracle

I=20 have another question about Oracle performance... I want to import MS = Access to=20 Oracle (Delphi=20 as programming tool). But all the mechanisms are slows. By SQL Loader = the=20 process of importing 2,000,000 registers take 2.5 hours (take in = account 30=20 mins. to parcer the file=20 in TEXT format). Using SQL Server, through link tables, I get the = same process=20 in 40 mins.

 

What=20 is the better and fast mechanism to import information to Oracle, = from MS=20 Access?

 

Thank=20 you!

 

Huascar=20 Espinoza

 

------_=_NextPart_001_01C4079C.656D6FE0-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------