Re: Help with changing the default directory

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 29 Apr 1999 21:12:08 +0200
Message-ID: <925412990.25557.0.muttley.d4ee154e@news.demon.nl>

Hi Ken,
Two tips: one or another you do have a shortcut in the start menu. Just change the working directory there, or create your own shortcut. Secondly: you can use environment variables in sql*plus (and other Oracle programs) by referring to them like this %<env var>%
in sql*plus this would mean
spool %TEMP%\someoutput.lis

and as far as I am concerned that is all.

Hth,

Sybrand Bakker, Oracle DBA

Kenneth Lewin wrote in message <3725E259.EEA8AA32_at_bah.com>...
>Hi all,
> When I run SQL*Plus on NT as a job in the background it spools
>to the default "ORAWIN/BIN" directory. Does anyone know how
>to alter SQL*Plus' default directory to go elsewhere by default.
>(Instead of just specifying it each time I log on.)
>
>Thanks in advance,
> -ken Lewin
Received on Thu Apr 29 1999 - 14:12:08 CDT