Re: Utility for extracting table's data into flat file ?

Shirley Donor wrote:
>
> Is there an Oracle Utility that can dump a table's data
> into a flat file ?
>
> Thank you very much.
>
> --

If you want to move table data between Oracle databases you can use utility exp (and imp). It dumps data in binary format, I quess.

To make an ASCII file you can try the following:

SQL> set pagesize 200000
SQL> -- Additional formatting commands here
SQL> spool myfile.txt
SQL> select * from mytable;
SQL> spool off

Now you have file myfile.txt in your working directory.

Hope this helps.

-- 

Timo Haatainen
Carelcomp Forest Oy