Re: How to export to comma delimited file from Oracle8?

Kelly -

A low-tech solution is simply to use SQL*Plus to spool out a select statement, something like

set feedback off
set pages 0
spool my_dump
select col_a||','||col_b||','||to_char(col_c) from my_table; spool off

-- 
Regards,
Matt Connors

kgrigg_at_acxiom.com wrote in article <875562663.10888_at_dejanews.com>...


> Hello All!


> I am wanting to export the rows from an Oracle 8 database table to a


 comma


> delimited file.  I have been trying to use the export function in the

> Enterprise manager.  But, when I do this, I get a file that looks like it

> has information on re-creating the tables, etc, along with the data with

> 'squares'  as a delimiter (seen while looking at the file with WordPad).

> Where can I look for info on this (a utility or commands from SQL*Plus)?

> 

> I am basically wanting to dunp the data out because I am dropping the

> tables I created while learning, use the new scripts I have written to

> create proper tablespaces, tables..etc.  And then re-load them from these

> dump files.

> 

> Any help greatly appreciated!!

> 

> Kelly

> kgrigg_at_acxiom.com

> 

> ps. Please cc by mail too, our newsfeed here isn't reliable...

> 

> -------------------==== Posted via Deja News ====-----------------------


>       http://www.dejanews.com/     Search, Read, Post to Usenet

>