downloading data into flat file ?

[silver40]

Hello

Could anyone please let me know how to "unload" a table into a flat file ?

I want to take all the data from a table and put it into a file.

I have created a 'master.sql' file with the followin lines of code:

set feedback off
set heading off spool slave.sql select 'select * from |'THISTABLE'|';
spool off

When I run 'master.sql' I am getting these errors.

./master.sql: spool: command not found

Thank you.

[dknight]

Try some reformatting:

set feedback off
set heading off
spool slave.sql

select 'select * from thistable'
from table_name;

spool off

You are spooling select statements to slave.sql. Your current sql*plus statement won't work without a from clause.

Good luck.