Re: Extract table data to file in ascii format

In article <1994Feb24.050810.902_at_csis.dit.csiro.au>, robertp_at_carina.csis.dit.csiro.au (Robert Andrew Power) writes:
> Is there an Oracle utility to extract the rows of a table into an external
> file in ASCII format?
>
> I can just spool the results of a query end edit the resulting file, but
> I was wondering if there is an inverse of SQL*Loader.
>
>
There was another thread on this just recently. SQL*Plus is it.

If you are interested, I have written a SQL*Plus script that will create another sqlplus script that dumps the data from a view or table into an ascii file. It also builds a SQL*Loader control file that will read that data back in.

If you're interested, send me an email note and I'll send it to you. I have a version that works for ORACLE6 and another that works for ORACLE7.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285