RE: DBA 101: SQLPATH on windows

From: Stephens, Chris <Chris.Stephens_at_adm.com>
Date: Fri, 8 Nov 2013 10:16:32 -0600
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A05006BBF251CE_at_JRCEXC1V1.research.na.admworld.com>

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_at_yahoo.com] Sent: Friday, November 08, 2013 9:46 AM
To: Stephens, Chris
Cc: oracle-l_at_freelists.org
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> _at_test.sql
SP2-0310: unable to open file "test.sql" SQL> _at_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.

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

Received on Fri Nov 08 2013 - 17:16:32 CET