Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: export to ascii file
> I would like to know how or where I might find information on how
> to export a table to an ascii file in ORACLE (for example, in SYBASE
> I would use the following:
>
> bcp databaseName..tableName out dataFile -c .....
A simple way, from SQL*Plus would be as follows:
spool c:\temp\textfile.txt
select * from mytable;
spool off
This will create an ASCII text file.
Daniel A. Morgan Received on Wed Apr 02 1997 - 00:00:00 CST