"Brian Peasland" <dba_at_nospam.peasland.net> wrote in message
news:J6zD8E.ADy_at_igsrsparc2.er.usgs.gov...
> Songs wrote:
>> 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
>>
>
> The SET and SPOOL commands that you have above are SQL*Plus commands,
> which mean very little to SQL Developer.
>
> In SQL Developer, you can run your script (F5) and see the results in the
> Script Output tab. And from that tab, you can save the output. Otherwise,
> I have yet to see anything in SQL Developer which lets you automatically
> spool the output to a file.
>
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
I also doubt that the spool file is in C:\. By default it will go to the
working directory, unless you specifically specified to use C:\ as the
startup directory.
--
Terry Dykstra
Received on Wed Oct 11 2006 - 12:03:51 CDT
