This error is most general error, everybody face this error either he is a student or trainee or experienced. Most of trainee starts from oracle and we generally used the SQL CMD to write the commands and execute the command. The feature of SQL CMD is that we can re-edit the SQL if it is not executed well, to use this feature we need to assign a buffer file where it can save the the previous execution history.
Error
SP2-0110: Cannot create save file "afiedt.buf"
SOLUTION-
1.Open CMD
2.set editor=notepad
3.open sqlplus and login with user
4.Thats it.
Error
SP2-0110: Cannot create save file "afiedt.buf"
SOLUTION-
1.Open CMD
2.set editor=notepad
3.open sqlplus and login with user
Thanks for your post. I have tried and read for hours to solve this problem: Oracle forum, Dba forums.
ReplyDeleteYou were of great help indeed!
Superb,
ReplyDeleteYou killed the problem in a nutshell. Hats Off to you. You have the 'ABC' of Oracle-SQL knowledge.
But there's one more important point to make note of - In the properties of SQL Plus, advanced, 'run as administrator' should be checked. This is an additional thing I had to do.
Thanks.
'ABC' - Accuracy Brevity Clarity
sp2-0110 cannot create save file afiedt.buf IN ORACLE 11G ON WINDOWS 7
ReplyDeletefantastic.. answer to the point.. its of great use.. thankX a lot
ReplyDeletethanks a lot bro
ReplyDeleteThanks Dear
ReplyDeleteHi Manish.... Thanks Thanks alot..
ReplyDeletei have checked "SQL Plus, advanced, 'run as administrator'" and it is working well... and i will definite check it out in future when i get new instance to work...
:-)
very good and easy solution.Thanks
ReplyDeleteSQL>set editfile d:/sqledit.sql
ReplyDelete