vi editor

[gps]

I cant seem to set up the editor to use vi. I have tried define_editor=vi, but I get the error:
sp2-0110 cannot create save file "afriedt.buf"

Has anyone had this problem before?

[kpnmani]

define ur editor at os level.

ie, EDITOR=vi;export EDITOR

then it should work.

[gps]

Its already defined in .profile.

[maachan]

Talk to your sys admin.
I had similar problems when I didn't have permissions in temp directory or when the temp directory was too full to write to.
Whenever vi is invoked, space in temp is needed.

maachan

[kpnmani]

Hi,
You will have to define vairable _editor.
on slqplus prompt,
SQL>define _EDITOR=vi

You can have this line define _EDITOR=vi in glogin.sql or login.sql
so that you need not define it everytime sqlplus is invoked.

You make sure that u have the full rights in temp & ur default directory.