RE: DBA 101: SQLPATH on windows
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Nov 2013 17:00:25 +0000
"the amount I've forgotten seems to be a constantly growing value."
You and me both.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mark W. Farnham
Sent: Saturday, November 09, 2013 3:04 AM
To: Chris.Stephens@xxxxxxx; 'Yong Huang'
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: DBA 101: SQLPATH on windows
The kurt franke response earlier in the thread shows setting multiple
directories. I don't recall if there is a way to set things to search
subdirectories other than as multiple listed search directories as kurt showed.
It would be a nice flag to be able to set on a destination; perhaps a trailing
/ would work semantically but as far as I know this would be an enhancement
request. Still, the amount I've forgotten seems to be a constantly growing
value.
mwf
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Stephens, Chris
Sent: Friday, November 08, 2013 11:17 AM
To: Yong Huang
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: RE: DBA 101: SQLPATH on windows
Huh. I swear I tested that out on Linux yesterday but it appears you are
right. That's the behavior on both Linux and Windows. Most of my scripts on
Linux are run through shell scripts and I rely on full path. It was only
yesterday I checked Linux for behavior that contradicts the documentation.
Chris
From: Yong Huang [mailto:yong321@xxxxxxxxx]
Sent: Friday, November 08, 2013 9:46 AM
To: Stephens, Chris
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: DBA 101: SQLPATH on windows
> I have to be explicit about each subdirectory in Windows but not in Linux.
The problem on Windows is described in
Subdirectories In SQLPATH Are Not Being Searched For SQL Scripts. Get Error:
SP2-0310: Unable to Open File "xyz.sql" (Doc ID 1524210.1)
I just tested this on Linux. It doesn't seem to work either. Can you show an
example on Linux?
$ pwd
/tmp
$ cat yong/test.sql
select * from dual;
$ export SQLPATH=/tmp
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 8 09:40:07 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP
and Data Mining options
SQL> @test.sql
SP2-0310: unable to open file "test.sql"
SQL> @yong/test.sql
D
-
X
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:
