Re: DBA 101: SQLPATH on windows
From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 8 Nov 2013 07:45:40 -0800 (PST)
Message-ID: <1383925540.17315.YahooMailNeo_at_web184801.mail.gq1.yahoo.com>
> 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
Date: Fri, 8 Nov 2013 07:45:40 -0800 (PST)
Message-ID: <1383925540.17315.YahooMailNeo_at_web184801.mail.gq1.yahoo.com>
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 08 2013 - 16:45:40 CET