This content has been marked as final. Show 17 replies
the afiedt.buf is written on same directory where you invoke sqlplus.
check OS permissions .... go to OS guide for how to
I am sure i have the permissions on teh directory.Check space on yours disk as well make sure the permission for rwe is granted.
Still getting SP2-0110: cannot create save file
Where is this afiedt.buf is wriiten?%ORACLE_HOME%\bin
check to see if you have the afiedt.buf in the current directory with
different owner than the username you are log in now - that might prevent you from override the file.
See what directory you are in:
Test whether you can create a file::
See whether the file already exists:
ls -l afiedt.buf
Check the properties of the SQL. Probably the 'Start In' option might be given wrong. Give the correct Path for the Start In.
Also search for the relevant threads in Forums, I had already given a solution for that.
i have granted the rwe permission to the directory....
Now when i write ....
select * from tablename ;
i can see the data but when i write
wrote file afiedt.buf
but not the query which i used to see in windows OS.
Do i need to change some settings....
what 26 means here.
> what 26 means here.
It's the number of characters in the file. The default editor is (rather unhelpfully) ed.
Create a file called login.sql and add the following line:
In RH Linux that should give you Vim. Or specify another editor that you prefer.
def _editor = vi
Message was edited by:
well i guess your initial problem is solved ...
you can invoke the editor from sqlplus.
when you write ed the default editor is invoked ( which is ed in linux/ unix)
you can change the default editor to be vi or other Linux editor installed.
by changing the _EDITOR - set parameter in sqlplus.
i advise you to read the sqlplus manual for more info ....
May be this will be useful to u.
sql>define_editor = vi
ur query will be seen in the afiedt.file.
try this out
But once the session is closed .... same thing happen and then for each session i write define_editor=vi.
Can we set the define_editor=vi for all sessions.
edit the file $ORACLE_HOME/sqlplus/admin/glogin.sql
definition you write in this file ALL users /session see.
U have to define that each time, that is for each sessions.
Upto me,No other way u can do it.