Dave: Your moving data from relational to relational DB. What about from hierarchical to relational?
Thanks, Ken Janusz, CPIM ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 2:36 PM exports 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" <[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: KENNETH JANUSZ INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
