Re: SQL*Plus afiedt.buf in Oracle 8.0.5

This is typically a pretty simple thing. SQL*Plus creates the file as the user you login as in the current working directory. Hence if your current user doesn't have permissions to write to that directory then you'll get the error. If you just run it from a directory where your user has permissions then you shouldn't have problems. Of course, you can always specify the name - ie. ed /tmp/myfile (it will automatically handle/add/expect the .sql extension). You can use the save command to write the current buffer to a file.

Geoffrey Bray
Tandy Corporation

In article <36DC8B78.5D4_at_acwilm.com>,
  younggs_at_acwilm.com wrote:
> I am using Oracle 8.0.5 on Linux and am having problems editing SQL
> commands from SQL*Plus - I keep getting the error message "cannot create
> save file afiedt.buf" when I try to edit unless I am logged in as the
> oracle user (dba group) that I used to install the software. After
> poking around, it seems changing permissions on my directories to 777
> allows afiedt.buf to be created, but it is owned oracle/dba and is
> created as rw-r--r--, so I still can't use it.
>
> I figure this is something small, but can't seem to figure it out...
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 04 1999 - 14:28:13 CST