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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfgang Breitling Sent: Monday, April 24, 2006 9:04 PM To: orcl@xxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l