Re: Easy way to dump table to flat file?

vv_at_mbunix (Vincent A Ventrone) wrote:
>
> A colleague has asked me to describe the easiest way to dump
> an Oracle table to a flat Unix file--and I did not have a ready answer.
>
> Any suggestions in netland??
>
> Thanks for any help.
>
> --
> Vince Ventrone
> The MITRE Corporation "...In my opinion, there's nothing
> Bedford, MA 01730 in this world beats a '52 Vincent
> vav_at_mitre.org and a redheaded girl." -- Richard Thompson

You can use sql*plus. The following sql*plus script dumps a table to unix file temp.lst.

set feedback off                      
set echo off                          
set pagesize 0                        
spool temp.lst                        
select *         
    from your_table;                

--
Jim Choate                                       choate_at_umis.upenn.edu 
University of Pennsylvania