Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g85Kg8Y02047 for ; Thu, 5 Sep 2002 16:42:08 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id LAA81866; Thu, 5 Sep 2002 11:40:47 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004C8EF2; Thu, 05 Sep 2002 11:36:11 -0800 Message-ID: Date: Thu, 05 Sep 2002 11:36:11 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Farnsworth, Dave" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Farnsworth, Dave" Subject: RE: Sql loader loads - what is the name of the counterpart that exports Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by naude.co.za id g85Kg8Y02047 Hate to say it but the M$ DTS utility works really nice for moving data between different platforms. You can move data directly from DB2 to Oracle if you want. It is not good for the very huge tables though. But if you need a quick transfer I can have a DTS setup in a minute or two. Dave -----Original Message----- Sent: Thursday, September 05, 2002 2:04 PM To: Multiple recipients of list ORACLE-L exports So Oracle thinks that people will only move into Oracle and not out of Oracle. Which makes me think. Is there a utility available in other DB's that can extract Oracle data out in plain text? To put this question in another way, how do you transfer data between different database vendors? Are there utilities out there that allows you to export and import data to and from other types of databases - Oracle to DB2 to MS SQL to Oracle .... ? Thanks. ltiu Philip Douglass wrote: >No such beast. But you can roll your own... :) > >Tom Kyte has a page that directly addresses this: >http://govt.oracle.com/~tkyte/flat/index.html > >-- Philip > >----- Original Message ----- >To: "Multiple recipients of list ORACLE-L" >Sent: Thursday, September 05, 2002 2:05 PM >exports > > >Hello guys, > >I just blurted out my whole message in the subject line. > >Here it is again? > >Sql loader loads - what is the name of the counterpart that exports >Oracle data in plain text? > >Export and Import does not handle plain ascii - these handle their own >proprietary binary format, which utility can export Oracle data out from >an Oracle database to a plain text file in comma-delimited format? > >Thanks for any tips. > >ltiu > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: ltiu > INET: ltiu@alumni.sfu.ca > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: ltiu@alumni.sfu.ca Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: DFarnsworth@Ashleyfurniture.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).