Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i | login.sql does not run on login by default

Re: Oracle 9i | login.sql does not run on login by default

From: Anoop <anoopkumarv_at_gmail.com>
Date: 10 Jan 2007 10:39:29 -0800
Message-ID: <1168454369.730482.172550@i56g2000hsf.googlegroups.com>


You say at least on 10.2!

Does anybody know if it is available on 9.2. I think the biggest benefit for me (if glogin is available) is that it will check when I reconnect and change teh sqlprompt appropriately... login.sql does not.

Thanks,
Anoop

On Jan 10, 1:18 pm, Niall Litchfield <niall.litchfi..._at_dial.pipex.com> wrote:
> Brian Peasland wrote:
> > mai..._at_bmlam.de wrote:
> >> In my experience, under Unix, Oracle looks for login.sql in your
> >> current directory. If none is found, it looks for login.sql in $SQLPATH
>
> >> hth
>
> >> Bon-Minh Lam
>
> > The order for finding the login.sql script is:
>
> > 1) Your current directory
> > 2) The directories listed (in order) in your SQLPATH environment variable
> > 3) The ORACLE_HOME/sqlplus/admin directory
>
> > Finally, the contents of the ORACLE_HOME/sqlplus/admin/glogin.sql script
> > are executed.
>
> > HTH,
> > Brianglogin.sql is executed before login.sql rather than afterwards - at
> least on 10.2. In addition option 3 isn't searched, at least in 10.2. I
> don't know if this a change from previous releases - I'd be surprised.
>
> --
> Niall Litchfield
> Oracle DBAhttp://www.orawin.info/services
Received on Wed Jan 10 2007 - 12:39:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US