Re: Where does STATSPACK save its reports generated with spreport

Of course if you specify an alternative you can specify a path in it.

On 9/8/05, oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> wrote:
>
> Not from what I've seen - with 9.2.0.6 <http://9.2.0.6> on Win2K3, when I
> run spreport.sql it saves the the output in my current working directory.
> You can see from the following lines in sprepins.sql (called by
> spreport.sql) that it just spools to your current directory:
>
> prompt
> prompt Specify the Report Name
> prompt ~~~~~~~~~~~~~~~~~~~~~~~
> prompt The default report file name is &dflt_name.. To use this name,
> prompt press <return> to continue, otherwise enter an alternative.
>
> set heading off;
> column report_name new_value report_name noprint;
> select 'Using the report name ' || nvl('&&report_name','&dflt_name')
> , nvl('&&report_name','&dflt_name') report_name
> from sys.dual;
> spool &report_name;
> set heading on;
> prompt
  

-- 


> Niall Litchfield

> Oracle DBA

> http://www.niall.litchfield.dial.pipex.com


--
http://www.freelists.org/webpage/oracle-l