Re: Sql loader loads - what is the name of the counterpart that exports
Sqplus works well for this as long as the file is not too large. Spooling to a file in sqlplus is quite slow. C or, ahem, Perl, are much faster. Jared - OCP and Part Time Perl Evangelist ;) On Thursday 05 September 2002 11:44, [EMAIL PROTECTED] wrote: > It's called SQL Plus. Set the heading off, pagesize = 0, linesize = 200, > set record delimiter = ',' or '|' and set feedback off; and termout on. > This should produce an ASCII file once you supply your own query. > > RWB > > > > > > ltiu <[EMAIL PROTECTED]>@fatcity.com on 09/05/2002 01:05:07 PM > > Please respond to [EMAIL PROTECTED] > > > > Sent by: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > 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: Jared Still 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).
Re: Sql loader loads - what is the name of the counterpart that exports
Thanks. Now I need to get M$ just to get Oracle to work for me. ltiu Farnsworth, Dave wrote: >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).
RE: Sql loader loads - what is the name of the counterpart that exports
set heading off set pagesize 0 set linesize 200 set feedback off set termout on select '"'|| e.empno || '",' || '"' || e.mgr || '",' || '"' || e.deptno || '",' from emp e where rownum <=10 ; > It's called SQL Plus. Set the heading off, pagesize = 0, > linesize = 200, set record delimiter = ',' or '|' and set > feedback off; and termout on. This should produce an ASCII > file once you supply your own query. > > RWB > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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).
Re: Sql loader loads - what is the name of the counterpart that exports
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).
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" <[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).
Re: Sql loader loads - what is the name of the counterpart that exports
OK. Very good. Wow!! Yes, this is what I am looking for. Thank you very much. ltiu [EMAIL PROTECTED] wrote: >It's called SQL Plus. Set the heading off, pagesize = 0, linesize = 200, >set record delimiter = ',' or '|' and set feedback off; and termout on. >This should produce an ASCII file once you supply your own query. > >RWB > > > > > >ltiu <[EMAIL PROTECTED]>@fatcity.com on 09/05/2002 01:05:07 PM > >Please respond to [EMAIL PROTECTED] > > > >Sent by: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc: > 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).
Re: Sql loader loads - what is the name of the counterpart that 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).
Re: Sql loader loads - what is the name of the counterpart that exports
It's called SQL Plus. Set the heading off, pagesize = 0, linesize = 200, set record delimiter = ',' or '|' and set feedback off; and termout on. This should produce an ASCII file once you supply your own query. RWB ltiu <[EMAIL PROTECTED]>@fatcity.com on 09/05/2002 01:05:07 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: 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: 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).
Re: Sql loader loads - what is the name of the counterpart that exports
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: Philip Douglass 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).
