Re: SQL*Plus login.sql in other than my current directory?

Dave Schweisguth wrote:
>
> Hi all,
>
> Can anyone tell me how to tell SQL*Plus that it should look for login.sql
> (its initialization file) somewhere other than the current directory?
>
> Thanks,
>
> --
> | Dave Schweisguth For purposes of complying with |
> | dcs_at_proton.chem.yale.edu (MIME OK) the New Jersey Right to Know Act: |
> | http://proton.chem.yale.edu/~dcs/ Contents partially unknown. |
> | Yale Depts. of MB&B & Chemistry Phone: 203-432-5208 Fax: 203-432-6144 |

It depends a little on what environment you are running in.

VMS

	Define ORA_PATH to be a search list of directory, one of which
	contains your login.sql, such as:

		$ DEFINE ORA_PATH [],SYS$LOGIN:,user1:[oracle.sql]

UNIX

	Define the environment variable ORACLE_PATH to define the 
	search path.  

	ORACLE_PATH=.:${HOME}:$ORACLE_BASE/local/sql
	export ORACLE_PATH

Windows/Win95/Mac

	I think that you can define ORACLE_PATH, or SQL_PATH, or 
	something like that, but I haven't tried it.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com