Re: Where does STATSPACK save its reports generated with spreport
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Thu, 8 Sep 2005 17:29:23 +0100
Of course if you specify an alternative you can specify a path in it.
On 9/8/05, oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
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
Other related posts:
