Brian Peasland wrote:
> mailto_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,
> Brian
>
glogin.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 DBA
http://www.orawin.info/services
Received on Wed Jan 10 2007 - 12:18:29 CST
