RE: Sql loader loads - what is the name of the counterpart that 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" <ORACLE-L_at_fatcity.com>
>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_at_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_at_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_at_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_at_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_at_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_at_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).