DBA 101: SQLPATH on windows
- From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Nov 2013 10:41:17 -0600
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.
Other related posts:
