Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Spool file to local machine
Just wondering if I can spool file to my local machine when I am using
Oracle Sql Developer.
When I ran the script and got this error message:
Unable to open file: "C:\countall.txt"
here is the script:
spool countall.txt
select 'SELECT count(*), '''||table_name||''' from '||table_name||';'
from user_tables
/
spool off
set termout on
@@countall.txt
set head on feed on