Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql script not running

Re: sql script not running

From: gamaz <gamaz_at_earthlink.net>
Date: Fri, 06 Sep 2002 11:01:40 GMT
Message-ID: <oW%d9.11077$6i4.890915@newsread1.prod.itd.earthlink.net>

Thanks a lot. I appreciate it.
"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:al9fvg$eg6$1_at_ctb-nnrp2.saix.net...
> gamaz wrote:
>
> > I have a personal version of Oracle. In the sqlplus prompt I am issuing
 a
> > command: start activity.sql to run a sql report. However I am getting an
> > error stating 'unable to open file'. I have kept the file activity.sql
> > under the bin subdirectory which is under orawin directory.
>
> Two choices.
>
> 1. Add the full path name to the script, e.g.
> SQL> start c:\orawin\bin\activity.sql
> (or SQL> @c:\bin\activity.sql)
>
> 2. Modify the shortcut that you use to run SQL*Plus (assuming you are
> running on Windows). Edit it and change the Working Directory to
> C:\orawin\bin (the shortcut's working directory is likely
> C:\Windows\Desktop).
>
>
>
> --
> Billy
>
Received on Fri Sep 06 2002 - 06:01:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US