From oracle-l-bounce@freelists.org Thu Mar 11 17:28:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2BNSRR00320 for ; Thu, 11 Mar 2004 17:28:27 -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 i2BNSRo00315 for ; Thu, 11 Mar 2004 17:28:27 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E6D2739C875; Thu, 11 Mar 2004 14:29:44 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 14:28:17 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from smtpgate.vicr.com (smtpgate.vicr.com [207.141.187.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 770AC396914 for ; Thu, 11 Mar 2004 13:59:16 -0500 (EST) Received: from 25exch1.vicorpower.vicr.com ([172.20.20.30]) by exchgate.vicorpower.vicr.com with Microsoft SMTPSVC(5.0.2195.5329); Thu, 11 Mar 2004 14:04:01 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4079B.9D6D68D8" Subject: RE: Importing MS Access to Oracle Date: Thu, 11 Mar 2004 14:04:01 -0500 Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D827B@25exch1.vicorpower.vicr.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Importing MS Access to Oracle Thread-Index: AcQHfq/bLiTk5JbsRtGMewxH8c9YrAAAX3ywAAbVaDA= From: "Goulet, Dick" To: X-OriginalArrivalTime: 11 Mar 2004 19:04:01.0790 (UTC) FILETIME=[9D8E71E0:01C4079B] X-archive-position: 526 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DGoulet@vicr.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C4079B.9D6D68D8 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable You can do the same thing with linked tables in Oracle. Just make sure = you pre-create the tables otherwise Access can do some non standard and = funny things. =20 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA=20 -----Original Message----- From: Huascar Espinoza [mailto:hespinoza@superele.gov.bo] Sent: Thursday, March 11, 2004 10:54 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. =20 What is the better and fast mechanism to import information to Oracle, = from MS Access? =20 Thank you! =20 Huascar Espinoza =20 ------_=_NextPart_001_01C4079B.9D6D68D8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
You=20 can do the same thing with linked tables in Oracle.  Just make sure = you=20 pre-create the tables otherwise Access can do some non standard and = funny=20 things.
 

Dick Goulet
Senior Oracle DBA
Oracle Certified = 8i=20 DBA

-----Original Message-----
From: Huascar Espinoza=20 [mailto:hespinoza@superele.gov.bo]
Sent: Thursday, March 11, = 2004=20 10:54 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_01C4079B.9D6D68D8-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------