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