RE: DBA 101: SQLPATH on windows

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 8 Nov 2013 09:03:33 -0500
Message-ID: <013501cedc8b$506eda10$f14c8e30$_at_rsiz.com>

Saving a .sql seems to make that the current directory for sqlplus sessions I'm running. (Not the full convenience that we used to have, but it can help for multiple projects work.)

You can also save multiple sqlplus items on the start menu and edit the directory they start in, another useful workaround.  

Your mileage may vary depending on windows and sqlplus releases. I just bang at it until something useful arises. I'm not aware of this being documented, but 7.1 was the last manual set I read cover to cover.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ric Van Dyke
Sent: Friday, November 08, 2013 8:20 AM
To: Chris.Stephens_at_adm.com; oracle-l_at_freelists.org Subject: RE: DBA 101: SQLPATH on windows  

Yes you are having the same experience as I have. In Windows it appears to NOT look in the subdirectories of the directories listed in SQLPATH. As for it being "expected" that is in the eye of the beholder, but that is the way it seems to work.  

I'm not sure how many folks use SQLPATH. It (like many things about SQL*Plus) seem to be lost over time, many folks using SQL*Developer or Toad or like GUI tools have forgotten or never learned how powerful SQL*Plus is and its related features like SQLPATH.  

Ric Van Dyke

Education Director

Hotsos Enterprises, Ltd

Hotsos Symposiun March 2-6 2014, Be There.        

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stephens, Chris
Sent: Thursday, November 07, 2013 11:41 AM To: 'oracle-l_at_freelists.org'
Subject: DBA 101: SQLPATH on windows  

From the docs:  

"The SQLPATH registry entry specifies the location of SQL scripts. SQL*Plus searches for SQL scripts in the current directory and then in the directories specified by the SQLPATH registry entry, and in the subdirectories of SQLPATH directories."  

I have accumulated a large number of scripts that I like to keep somewhat organized. For some reason I have to be explicit about each subdirectory in Windows but not in Linux. That's not really a problem until you start getting compulsive about organization and your SQLPATH string starts getting ridiculously long (I'm sure there's a limit at some point). I'd like to set SQLPATH registry value to "C:\sqlplus_scripts\" instead of explicitly listing the 20 or so subdirectories I have.  

Is that expected or am I doing something wrong? I'm guessing that if it was (contrary to what the documentation says), there would be complaints that show up on Google but I'm not seeing any which leads me to believe I'm doing this wrong.  

Thanks for any help.  

CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 08 2013 - 15:03:33 CET