change statspack default report location

[lhugh]

how do I change the default report location when you run spreport.sql?

What is the default location and how do I change it?

for some reason my reports are being saves to C:\ directory

Thank you

 

[stefanhei]

Hi.
The default report location can be set by specifying the uservariable report_name. Issue
define report_name=<yourReportPathAndName>
before calling $ORACLE_HOME/rdbms/admin/spreport.sql.

Stefan

 

[lhugh]

thank you