Re: login.sql search path?

A couple of extras:

SQL*Plus first executes

    $ORACLE_HOME/sqlplus/admin/glogin.sql

Then searches the SQLPATH until it finds a login.sql and executes it. (it stops after the first one). You can specify multiple paths by using a ';' as a separator, e.g.

export SQLPATH=${HOME};.;/u02/app/my_app/scripts/sql

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Doug O'Leary wrote in message


>Hey;

>

>Aint that amazing; you post a question, do a little more searching

>and find the answer.

>

>export SQLPATH=${HOME}

>

>does wonders.

>

>Doug

>

>--

>------------------------

>Douglas K. O'Leary

>Senior System Administrator

>dkoleary_at_mediaone.net