Re: Set SQLPlus Default Directory

In article <32ad0c3e.1864541_at_news.bernoise.ch>, Marc Scheuner <marc.scheuner_at_bernoise.ch> writes
>Jim Smith <jim_at_jimsmith.demon.co.uk> wrote:
>>>>set environment variable in autoexec.bat:
>>>>set SQLPATH=c:\scripts
>>Put a setting of the same name in ORACLE.INI
>No can do, since the Oracle stuff (including ORACLE.INI) is on a
>write-protected network drive,.......
>

All you can do is ask your DBA to be more flexible and allow for customised Oracle.ini files

>>I assume that for 32-bit versions you would put a similar entry in the
>>Registry
>But you wouldn't happen to know which one, or where to look up
>something like this??
>

On my Win95 machine at home it is

HKEY_LOCAL_MACHINE/Software/Oracle/SQLPATH

The ORACLE.INI settings are usually documented at the end of the Installation and User Guide, so I guess the same would be true of Registry settings. I think it would be safe to assume that the meaning of registry settings will be the same as for ORACLE.INI settings.

But remember, this will NOT work for 16-bit tools, the only thing for them is ORACLE.INI
>Marc
>
 

-- 
Jim Smith