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
ECTED]
Sent by: cc:
[EMAIL PROTECTED]Subject: Re: How to tell Oracle the
directories of script
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
>
>
>
>
> [EMAIL PROTECTED]
>
> ys.utk.edu To:
> [EMAIL PROTECTED]
>
> Sent by: cc:
>
>
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
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:
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
@/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
by: cc:
[EMAIL PROTECTED] Subject: How to tell
Oracle the directories of script files
:
[EMAIL PROTECTED] Subject: How to tell Oracle the
directories of script files
om
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
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
12 matches
Mail list logo