Re: How to export parts of a oracle table

How about spooling a select statment to a text file and using that as an import to a text file?

set spool import.txt
select firstname,lastname,zip_code from customer where lastname="SMITH" order by lastname
set spool off

You get a report in import.txt as an ascii file. You probably have to do some data massaging afterwards...

But there are better methods available... It all depends on what system you want to export to... Received on Tue Jan 12 1999 - 21:40:41 CST