From oracle-l-bounce@freelists.org Thu Mar 11 16:56:43 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2BMugG30308 for ; Thu, 11 Mar 2004 16:56:42 -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 i2BMueo30298 for ; Thu, 11 Mar 2004 16:56:40 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7CB6639CEC9; Thu, 11 Mar 2004 16:35:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Mar 2004 16:34:35 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from correo.super.gov.bo (unknown [200.87.97.206]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 56902395F2C for ; Thu, 11 Mar 2004 15:08:14 -0500 (EST) Subject: RE: Importing MS Access to Oracle MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C407A5.69D30A2E" Date: Thu, 11 Mar 2004 16:14:09 -0400 Message-ID: X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Importing MS Access to Oracle Thread-Index: AcQHfq/bLiTk5JbsRtGMewxH8c9YrAAAX3ywAAbVaDAAAlVvAA== From: "Huascar Espinoza" To: X-archive-position: 554 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: hespinoza@superele.gov.bo Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C407A5.69D30A2E Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have the same problem with link tables, process is so slow. The same process with SQL Loader (2.5 hours) take 4 hours with link tables.:-( =20 Thank you, =20 Huascar =20 -----Mensaje original----- De: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] En nombre de Goulet, Dick Enviado el: Jueves 11 de Marzo de 2004 15:04 Para: oracle-l@freelists.org Asunto: RE: Importing MS Access to Oracle =20 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_01C407A5.69D30A2E Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have the same problem with link tables, process is so slow. The same = process with SQL Loader (2.5 hours) take 4 hours with link = tables.L

 

Thank you,

 

Huascar

 

-----M= ensaje original-----
De: = oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] En nombre de Goulet, Dick
Enviado el: Jueves 11 de = Marzo de 2004 15:04
Para: = oracle-l@freelists.org
Asunto: RE: Importing MS = Access to Oracle

 

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.

 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----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.

 

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

 

Thank = you!

 

Huascar = Espinoza

 

------_=_NextPart_001_01C407A5.69D30A2E-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------