Re: Need a SQL*UNLoader

In article <rwh4+.160.000FBCA0_at_pitt.edu> you wrote:
>In article <3chrgs$cc5_at_killerbee.jsc.nasa.gov> sspruell_at_ssf3.jsc.nasa.gov (Steven Spruell)
 writes:
>>From: sspruell_at_ssf3.jsc.nasa.gov (Steven Spruell)
>>Subject: Need a SQL*UNLoader
>>Date: 12 Dec 1994 15:50:52 GMT
 

>>Has anyone got any info on products or techniques to generate a delimited
>>export file from Oracle tables? I know I can use sqlplus or Reports and
>>generate a seperate report for each table, but I was looking for something
>>a little more generic. I guess Oracle is under the impression that no one
>>would ever want to EXPORT data FROM Oracle, sort of like once you've reached
>>nirvana, why would you want to go back?
>
>I've never actually tried this (I guess I'm in nirvana :-), but,
>
>1. Go into SQLPLUS.
>2. set echo off
>3. set heading off
>4. set termout off
>5. set feedback off
>6. spool <output file name>
>7. select <field 1>||','||<field 2>||','||<field 3> (etc) from (etc);
>8. spool off
>9. exit
>
>Let me know how it works out.
>

I've got a similar requirement to unload data from a table (to reload into another Oracle 7 database) which also includes a LONG RAW column. I can't use EXPORT/IMPORT as I want to selectively unload the data and I can't use a select statement in SQL*Plus to do this because of the LONG RAW column.

Any suggestions?

--
Enrico Soldani                     clemnet_at_tmx.mhs.oz.au
Clemenger/BBDO                     +61 2 925 5324