Re: How to tell Oracle the directories of script files

2003-08-16 Thread Reuben D. Budiardja
Thanks all. The replies have been really helpful. Reuben D. Budiardja. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mail

Re: How to tell Oracle the directories of script files

2003-08-14 Thread Ron Thomas
ECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: How to tell Oracle the directories of script

RE: How to tell Oracle the directories of script files

2003-08-14 Thread Anderson, Brian
2003 2:20 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: How to tell Oracle the directories of script files > > > export SQLPATH=/usr/users/oracle/dba/scripts:/app/oracle/admin > > before you run SQL*Plus > > HTH > Stephen > > >>> [EM

Re: How to tell Oracle the directories of script files

2003-08-14 Thread Tanel Poder
> > > > > [EMAIL PROTECTED] > > ys.utk.edu To: > [EMAIL PROTECTED] > > Sent by: cc: > >

Re: How to tell Oracle the directories of script files

2003-08-14 Thread Stephen Andert
export SQLPATH=/usr/users/oracle/dba/scripts:/app/oracle/admin before you run SQL*Plus HTH Stephen >>> [EMAIL PROTECTED] 08/14/03 11:09AM >>> Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user di

RE: How to tell Oracle the directories of script files

2003-08-14 Thread Browett, Darren
I have setup an environment variable (actually a number of them) DBS=/ora/app/dba/scripts ; export DBS In my case this is where the majority of my scripts are stored when I am in sqlplus SQL> @$DBS/scriptname Darren -Original Message- Sent: Thursday, August 14, 2003 11:09 AM To:

RE: How to tell Oracle the directories of script files

2003-08-14 Thread Goulet, Dick
It's known as SQLPATH. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, August 14, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I s

RE: How to tell Oracle the directories of script files

2003-08-14 Thread Nelson, Allan
@/usr/local/bin/my_sql_script Allan -Original Message- Sent: Thursday, August 14, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user

Re: How to tell Oracle the directories of script files

2003-08-14 Thread Ron Rogers
by: cc: [EMAIL PROTECTED] Subject: How to tell Oracle the directories of script files

Re: How to tell Oracle the directories of script files

2003-08-14 Thread Reginald . W . Bailey
: [EMAIL PROTECTED] Subject: How to tell Oracle the directories of script files om

How to tell Oracle the directories of script files

2003-08-14 Thread Reuben D. Budiardja
Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user directories, I can load/execute the script by doing: SQL> @scriptname But what if I don't start sqlplus from that directories? How do I tell Orac

RE: How to tell Oracle the directories of script files

2003-08-14 Thread Martin, Alan (Contractor) (DLIS)
Title: RE: How to tell Oracle the directories of script files Use SQLPATH. Alan Martin Defense Logistics Info Service Battle Creek, MI -Original Message- From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 14, 2003 2:09 PM To: Multiple recipients of list