Btw, did you know that you can use:
@http://www.servername.com/script.sql and
@ftp://ftp.servername.com/dir/script.sql in 9i sqlplus :)
It can be nice in environment where you continously have to work with random
different servers and cant copy your script set over every time..
Tanel.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, August 14, 2003 10:34 PM
> RDB,
> It is always best to include the path for the script that you want to
> execute. That way you make sure that you execute your script and not
> someone else's. There can be many scripts of the same name in the
> directory path.
> Ron
> >>> Reginald.W.Bailey_at_jpmorgan.com 08/14/03 03:19PM >>>
>
> Yes there is a way. In UNIX environments (I think this works in
> NT/2000 as
> well) you can set the environment variable SQLPATH to a list of
> directories
> that contain SQL files. SQLPlus will search this path if the file is
> not
> found in the current directory.
>
> RWB
>
>
>
> Reginald W. Bailey
> IBM Global Services - ETS SW GDSD - Database Management
> Your Friendly Neighborhood DBA
> 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)
> reginald.w.bailey_at_jpmorgan.com
> baileyre_at_us.ibm.com
>
>
>
>
>
> techlist_at_voyager.ph
>
> ys.utk.edu To:
> ORACLE-L_at_fatcity.com
>
> Sent by: cc:
>
> ml-errors_at_fatcity.c Subject: How to tell
> Oracle the directories of script files
> om
>
>
>
>
>
> 08/14/2003 01:09 PM
>
> Please respond to
>
> 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 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
> Oracle
> to find the scripts in /home/user, then if it's not there in
> /usr/local/bin,
> for example? So that I can be anywhere in the filesystem when starting
> sqlplus and can execute my SQL script.
>
> Just like the $PATH environment variables in *nix system that tell the
> shell
> where to find executables, is there a similar thing for Oracle?
>
> Thanks for any help.
>
> RDB
>
> --
> Reuben D. Budiardja
> Department of Physics and Astronomy
> The University of Tennessee, Knoxville, TN
> -------------------------------------------------
> /"\ ASCII Ribbon Campaign against HTML
> \ / email and proprietary format
> X attachments.
> / \
> -------------------------------------------------
> Have you been used by Microsoft today?
> Choose your life. Choose freedom.
> Choose LINUX.
> -------------------------------------------------
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Reuben D. Budiardja
> INET: techlist_at_voyager.phys.utk.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Reginald.W.Bailey_at_jpmorgan.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: tanel.poder.003_at_mail.ee
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Aug 14 2003 - 18:24:25 CDT
