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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Basic SQL*PLUS Question

Re: Basic SQL*PLUS Question

From: Steve Clements <sclements_at_enterprise.net>
Date: 1997/11/05
Message-ID: <3460c9ae.9273065@news.enterprise.net>#1/1

"Chinna" <jchinna_at_enron.com> 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

Normally Oracle will put spool and save files in the BIN directory where the Oracle applications are installed.

Your error message indicates that you don't have write privilege to that directory or, possibly, it is full.

Hopr that helps

Steve Received on Wed Nov 05 1997 - 00:00:00 CST

Original text of this message

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