Re: Path for login.sql

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/06/26
Message-ID: <33b3ba30.20911559_at_newshost>#1/1

You can set an environment variable SQLPATH to point to a directory that sqlplus will search for scripts and start up files (in addition to the current working directory).

So each user can set SQLPATH=$HOME

On Thu, 26 Jun 1997 17:06:23 GMT, Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de (Gerhard Moeller) wrote:

>Hi,
>
>sorry for my stupid question, but how can I set the path sqlplus
>should search for the login.sql. Especially, I would like to have a
>global login.sql in some oracle dir and for each user a personal
>login.sql in her $home.
>
>On my system, login.sql is only accepted from within the directory
>where sqlplus is started.
>
>System: DEC alpha osf 3.2, oracle 7.3.2
>
> Thank you, Gerhard.
>--
> Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE
>
>OFFIS | | | | | | Tel.: 0441/9722-122
>Escherweg 2 | | | | | | Sekr.: 0441/9722-113 oder -101
>D-26121 Oldenburg |O|F|F|I|S| Fax: 0441/9722-102

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jun 26 1997 - 00:00:00 CEST