Re: DBA 101: SQLPATH on windows
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Yong Huang <yong321@xxxxxxxxx>
- Date: Mon, 11 Nov 2013 17:20:30 +0000
I'm glad you posted this, since my experience on windows and linux has
always (for memory values of always :) ) been that SQLPATH requires each
directory to be separately listed and that there's a limit. For this reason
many of the boxes I have been on will have either c:\scripts or
/u01/scripts in them. :)
On Fri, Nov 8, 2013 at 3:45 PM, Yong Huang <yong321@xxxxxxxxx> wrote:
> > 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
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
