Re: Basic SQL*PLUS Question

Chinna wrote:
>
> Hi,
>
> How to specify the directory/find out default directory where SQL*PLUS
> stores the SQL scripts.
>
> example :
>
> SQL> select count(*) from tab;
>
> 15
>
> SQL> save count.sql
> cannot create save file
>
> Any ideas/suggestions are appreciated.
>
> Thanks
> Chinna
Hi Chinna,

IMHO, SQL*Plus saves every file in the current working directory which is probably the binary directory where the SQL*Plus executable is stored.
I believe you do not have the permissions to write to that directory. Just specify a directory to store the file to:   On Unix:
  SQL> save /home/chinna/sql/count.sql
  On Windows:
  SQL> save c:\home\chinna\sql\count.sql or something similar.

HTH.
  Harry

-- 
                                                      ///
  Hiroshima '45   Chernobyl '86   Windows '95        (O O)
-------------------------------------------------oOO--(_)--OOo---------
  "There is more than one way to do it!"

(Remove -NOSPAM- from my email address)