RE: sqlpath default sql dir for unix

We use AIX 5.2L and I have been using "export SQLPATH=$HOME/ora:$HOME" for a couple of releases, 8.1.7 - 10.1.0.4, without a problem.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling Sent: Monday, April 24, 2006 9:04 PM
To: orcl_at_comcast.net
Cc: oracle-l
Subject: Re: sqlpath default sql dir for unix

In unix set the ORACLE_PATH environment variable to the directory(ies) of your sql scripts.

> "in windows, users dont have a concept or a working dir, so the
> variable is needed. In unix its the current director you are in. In
> unix the SQLPATH is used to point to the location of glogin.sql ". I
> know I can set a env variable, but how to get sql plus to recognize
> it? I like to have my sql scripts close at hand, without having to
> remember to cd into that dir. How do people handle this?
>

--
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l