Saturday, June 4, 2011

Solution of SP2-0110: Cannot create save file "afiedt.buf": [How to Solve] SP2-0110: Cannot create save file "afiedt.buf" Error in Oracle?

After completion of Oracle 10g or 11g on your Windows 7 computer, you would like to practice the Oracle SQL in Oracle SQL*Plus. Definitely you can do it but sometimes you mistake to write the full command correctly. But what do you do? Generally you would like to use the ed or edit command from the Oracle SQL*Plus prompt and like to correct the errors of your SQL syntax. But you can not do. You are getting the error message like SP2-0110: Cannot create save file "afiedt.buf". Most people, who are using Oracle in Windows 7 operating system, get this error message firstly. But how to solve it. Hopefully, you already searched lots of place for the solution of this. You may get lots of articles or lots of documents to solve this simple error but you could not solve the error totally. The good news is that, you will find the complete and easy solution here to solve the problem or error SP2-0110: Cannot create save file "afiedt.buf" in the following paragraphs.

Cannot create save file afiedt.buf

The cause of of the error SP2-0110: Cannot create save file "afiedt.buf" occurs due to the problem of Oracle installation destination or directory permission . But this can be easily solved following the mentioned steps:

  1. Create a folder in any place of your computer. For example, we create a folder in G directory and named it as MyOracle folder.
  2. Go to the Oracle installation directory and browse through the bin directory to find out the sqlplusw file. For example, the installation location of Oracle 10g is G:\oracle\product\10.2.0\db_1\bin in our computer. So, we have to go there and find out sqlplusw file. Now, copy a shortcut of this file and copy the shortcut and past it to the folder which we created in step 1.
  3. Let’s try this by double clicking and type the sql commands. Now, type ed or edit command and hit Enter key of your keyboard. What you are seeing? Is there any error? No error at all and the edit prompt to modify the command is opened to a notepad or any other text editor.

And that’s all. Hopefully, following the above mentioned steps you can easily remove the error SP2-0110: Cannot create save file "afiedt.buf" and can easily edit the commands. Moreover, if you face any other difficulties then please mention in the comment section and I will try to solve that problem.

34 comments:

  1. Ya It Does...............!
    Thank You Sir !

    ReplyDelete
  2. I am using oracle 10g and tried the above steps, however am still getting the same error. Please help me....

    ReplyDelete
    Replies
    1. Above is the wrong solution Sameer.

      Delete
    2. If you went in properties of shortcut and advanced option then you have to click on Run as Administrator then only it will work.
      Precaution- 1) Dont delete created short cut

      Delete
    3. dude i m also facing same problem..pls tel me the solution for this.. im not getting where is properties of shortcut...

      Delete
    4. Thanks alot Mukesh Pandey, it works now for me

      Delete
  3. Finally I figured it out, thanks....

    ReplyDelete
    Replies
    1. hey can u plzz help me how u did? i m having same situation, plzzz help me out

      Delete
  4. create a folder in any directory simply goto the command promt through command promt you should connect with your uername and password.

    ReplyDelete
  5. still getting same error............please help me

    ReplyDelete
    Replies
    1. its simple follow the process of Mandeep ji

      Delete
  6. Hello Here I am unable to correct the problem with which you given plz. help me If there is any other solution.
    Thanks,
    Murali

    ReplyDelete
  7. Good Yar!!! this post really solved my problem.... Thank you once again

    ReplyDelete
  8. thank u so much it is working...but one more problem ...whenever im typing cl scr it shows the error 'no command interpreter' please help............

    ReplyDelete
  9. I donot have the sqlplusw file in my oracle bin folder and I am not able to open the oracle SQL*Plus application also on my system. I have installed oracle 11g on my windows 7 .Please help me out!!

    ReplyDelete
  10. It worked. But in 10g version the sqlplus is located in a different location; you have specified the location for an older version, it seems. Anyways, your solution helped me, Thanks.

    ReplyDelete
  11. Right click on 'sql plus' and select run as administrator than it will definatly works...this is right approach for 11g and 10g on windows 7...thanks mukesh pandey...

    ReplyDelete
  12. thanks sir,the option u said "Right click on 'sql plus' and select run as administrator than it will definatly works...this is right approach for 11g and 10g on windows 7" worked...thank u very much.....

    ReplyDelete
  13. guys simly try this
    SQL>set editfile d:/sqledit.sql

    ReplyDelete
  14. There is no need to create a shortcut, you can directly right click on sqlplus and run as administrator and ed will work.

    One question: Why do we have to run is as administrator?

    ReplyDelete
    Replies
    1. Than u Mandeep ji ........... this is so simple every one is making it complicated

      thnx again

      Delete
  15. So thanks its working...........

    ReplyDelete
  16. Cl scr not working..how to solve this

    ReplyDelete