Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Spool file to local machine

Spool file to local machine

From: Songs <shulinsong1_at_gmail.com>
Date: 11 Oct 2006 09:01:35 -0700
Message-ID: <1160582495.493663.198500@k70g2000cwa.googlegroups.com>


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:



set termout off echo off feed off trimspool on head off pages 0

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



Please advice.
Thanks,
Bill Received on Wed Oct 11 2006 - 11:01:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US