SPOOL File Location

[Mahesh]

Hi,

Can u tell me , From where can i change the default location of SPOOL
file.

Whenever i do spool on and off , the files been generated at
oracle_home\mydb\bin\

I don't want to specify any path each time. Where oracle store this
PATH related information.

Thanks in advance

Mahesh

[ora...@msn.com]

Comments embedded.

On Aug 21, 6:41 am, Mahesh <maahi2...@gmail.com> wrote:
> Hi,
>
> Can u tell me , From where can i change the default location of SPOOL
> file.
>

Nowhere.

> Whenever i do spool on and off , the files been generated at
> oracle_home\mydb\bin\
>

Which is where your sqlplusw.exe session begins.

> I don't want to specify any path each time.

Then change the start directory in the shortcut to the location where
you want your spooled files to reside. If you can't be bothered to
type in a few more characters for your spool file name ...

> Where oracle store this
> PATH related information.
>

Nowhere.

> Thanks in advance
>
> Mahesh


David Fitzjarrell

[eswaran kaliappan]

Hi Mahesh,

 

It seems you are running your sql*plus session from that directory. 

sql*plus understands that  oracle_home\mydb\bin\ is ur current directory. so it spools the file to that location

Instead of that if you give spool d:\output.lst, u can see @ d:

 

Otherwise, you can invoke sqlplusw from your d:\, so you can get spool file there itself.

 

I would suggest you to create a custom sql script and run once after u logged in. It would do

 

Cheers,

K Eswaran

 

Hi,

 

You can do