Oracle-L: Re: How to tell Oracle the directories of script files

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Thu, 14 Aug 2003 16:34:23 -0800
Message-ID: <F001.005CABC5.20030814163423@fatcity.com>

COOL! I've learned something new today. Can I go home????

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                                                                                                                                                  
                      tanel.poder.003_at_m                                                                                                           
                      ail.ee                   To:       ORACLE-L_at_fatcity.com                                                                     
                      Sent by:                 cc:                                                                                                
                      ml-errors_at_fatcity        Subject:  Re: How to tell Oracle the directories of script files                                   
                      .com                                                                                                                        
                                                                                                                                                  
                                                                                                                                                  
                      08/14/2003 05:24                                                                                                            
                      PM                                                                                                                          
                      Please respond to                                                                                                           
                      ORACLE-L

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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Thomas
  INET: rthomas_at_hypercom.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).

Received on Thu Aug 14 2003 - 19:34:23 CDT