DBA 101: SQLPATH on windows

From: Stephens, Chris <Chris.Stephens_at_adm.com>
Date: Thu, 7 Nov 2013 10:41:17 -0600
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A05006BBF24FC1_at_JRCEXC1V1.research.na.admworld.com>



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 Thu Nov 07 2013 - 17:41:17 CET

Original text of this message