SP2-0110: Cannot create save file "afiedt.buf"

Any query/command (single line or multiple line) we execute resides in the buffer temporarily and it is lost when we execute new query/command because new one takes that place.

 In case we try to edit that query/command which is in the buffer we get an error "SP2-0110: Cannot create save file "afiedt.buf"".

 There are many ways to fix this, I'm going to show you three different ways.
1. Always run the SQL Command Line as administrator.

Once you start this way, you will not see said error.


2. Sometimes we get this error message because we don't have write permission on the current directory. Either start sqlplus from a different directory, or change the editfile entry in sqlplus:

 SQL>set editfile d:/sqledit.sql

 In above code, you can use any drive for this and any file name.

 3. Create sqledit.sql file and save it in bin directory (sometimes this file misses cause this error) of oracle where sqlplus.exe is resides.Then run sql command line as administrator.

Comments

  1. GhufranWednesday, October 03, 2012 1:24:00 pm

    nice thanks alottt brother

    ReplyDelete
  2. Mastan MohammedWednesday, October 17, 2012 8:56:00 pm

    thanq u brother

    ReplyDelete
  3. AnonymousTuesday, October 23, 2012 7:45:00 am

    man it really worked thanks alot

    ReplyDelete
  4. DeepaSunday, November 04, 2012 10:42:00 pm

    working correctly .. thanks a lot
    Deepa

    ReplyDelete
  5. chennaMonday, December 17, 2012 3:50:00 am

    nice its working

    ReplyDelete
  6. UnknownWednesday, December 26, 2012 9:00:00 am

    Thanks its working

    ReplyDelete
  7. ugadiMonday, January 07, 2013 7:26:00 am

    thanks ,,,, it is working

    ReplyDelete
  8. netguySaturday, January 19, 2013 11:04:00 pm

    thanks....working perfectly...

    ReplyDelete
  9. AnonymousTuesday, February 05, 2013 12:22:00 am

    Good One!!

    ReplyDelete
  10. AnonymousTuesday, February 05, 2013 6:18:00 pm

    Thanks Bro.

    ReplyDelete
  11. AnonymousFriday, March 08, 2013 11:02:00 pm

    thank uuuuu

    ReplyDelete
  12. AnonymousThursday, March 21, 2013 8:45:00 am

    thanks anyway

    ReplyDelete
  13. AnonymousTuesday, April 30, 2013 4:23:00 am

    Works a treat, thanks mate!

    ReplyDelete
  14. UnknownFriday, June 07, 2013 12:28:00 am

    bt we need to write it evry time we open sqlplus..how to avoid it.?

    ReplyDelete
  15. UnknownThursday, June 13, 2013 7:48:00 am

    Thanks a lot bro you really help me :)

    ReplyDelete
  16. AnonymousThursday, July 04, 2013 8:16:00 pm

    Thanks a lot...

    ReplyDelete
  17. UnknownSaturday, August 17, 2013 1:02:00 pm

    1. Open Cmd
    2. type set editor=notepad
    3. type sqlplus & login and open notepad

    ReplyDelete
  18. UnknownSaturday, August 17, 2013 1:03:00 pm

    1. Open Cmd
    2. type set editor=notepad
    3. type sqlplus & login and open notepad

    ReplyDelete
    Replies
    1. AnonymousFriday, August 23, 2013 10:35:00 pm

      I want to set the editor permanently for the Oracle Sqlplus. The above steps are working at cmd prompt and not for sql .

      Delete
  19. AnonymousFriday, August 23, 2013 10:36:00 pm

    its not working for me when I am trying to set for Oracle Sqlplus

    ReplyDelete
  20. AnonymousWednesday, September 11, 2013 1:35:00 pm

    Thanks Working..!!

    ReplyDelete
  21. UnknownSunday, September 22, 2013 8:58:00 am

    Thanks............bos.....

    ReplyDelete
  22. movenMonday, January 13, 2014 5:24:00 am

    I dont want to enter "set editfile d:/sqledit.sql " each time i open sqlplus ..how do I make this permanent? Thank you for the knowledge ,,it's working though not permanent.

    ReplyDelete
    Replies
    1. harshWednesday, February 05, 2014 10:46:00 am

      same case with me.. i have to enter this each time.. how do i make this permanant? have u got any solution for this?? plz let me know if yes..

      Delete
  23. harshWednesday, February 05, 2014 10:48:00 am

    same case with me.. i have to enter this each time.. how can it be permanent?? have u got any soln for this?? plz let me know if yes..

    ReplyDelete
  24. AnonymousSaturday, March 01, 2014 2:44:00 am

    Now working fine, Thanks bro

    ReplyDelete
  25. UnknownSaturday, March 08, 2014 5:08:00 am

    Hi Boss,
    when i use ed command in sql command prompt a note pad is opening but it was saying "cannot find the /.sql file"...iam unable to see the queries too...please help me to fix this

    ReplyDelete
    Replies
    1. Abhimanyu Kumar VatsaSaturday, March 08, 2014 5:14:00 am

      I have provided 3 resolutions above. You are trying to execute ed or edit buffer command..right? If so, the 1st resolution will work well for you. 2nd resolution only works till current session. 3rd resolution will work permanently but this helps when you have no sqledit.sql at the location (your location might be different depending on version you have installed) C:\oraclexe\app\oracle\product\11.2.0\server\BIN\

      Delete
  26. AnonymousSaturday, March 08, 2014 5:10:00 am

    Hi please help me...iam uable to open the queries with ed command...it was opening a note pas file but showing "cannot fine /.sql file"

    please help me

    ReplyDelete
  27. AnonymousThursday, June 05, 2014 12:07:00 am

    Good, thanks

    ReplyDelete
  28. AnonymousSunday, July 06, 2014 10:33:00 pm

    Thank you,, it works....

    ReplyDelete
  29. UnknownSunday, August 10, 2014 8:25:00 am

    open a notepad and save it as "sqledit.sql" in the sqlplus.exe contating directory (in case unable to found search in start button).Then run sqlplus as admin

    ReplyDelete
  30. UnknownSaturday, November 15, 2014 3:19:00 am

    it's working fine.. thnx bro..

    ReplyDelete
  31. AnonymousFriday, December 12, 2014 8:39:00 am

    good.. it was helpful

    ReplyDelete
  32. UnknownTuesday, February 10, 2015 9:36:00 am

    thanks bhai.....

    ReplyDelete
  33. Naveen MurugaMonday, March 28, 2016 5:32:00 am

    It wont work in my systems

    ReplyDelete
  34. UnknownWednesday, May 25, 2016 4:41:00 am

    It's working thanks bro..

    ReplyDelete
  35. UnknownThursday, August 04, 2016 9:53:00 pm

    thanks bro!

    ReplyDelete

Post a Comment

Popular posts from this blog

Migrating database from ASP.NET Identity to ASP.NET Core Identity

Image
As you know ASP.NET Core Identity (table structure) is different from what we had earlier in ASP.NET Identity. Actually the identity system which we have today with .NET Core is very mature and continuously evolved be it ASP.NET Membership, ASP.NET Identity 1, ASP.NET Identity 2 and now ASP.NET Core Identity. Recently I had to migrate few application to ASP.NET Core and similar its identity database. Because the table schema is changed, i had to re-think and create migration script which I would like to share with you today. It is very simple and easy, just three step and I had everything ready: STEP 1 : Change name of existing tables STEP 2 : Create ASP.NET Core Identity tables STEP 3 : Migrate data from old tables (ASP.NET Identity) to new tables (ASP.NET Core Identity) Script:  https://gist.github.com/itorian/c699e8534b392a6c726ec66c48100072 You should also watch my video, where I demoed migration.
Read More »

Customize User's Profile in ASP.NET Identity System

Image
Note: You should read this post instead, I found below walkthrough will not work on ASP.NET Identity 2. I will re-work on this post soon. In this post you will learn how to customize User’s Profile and add some more fields like FirstName, LastName, EmailID etc with ASP.NET Identity System. In my last post I listed some of the great new features introduced with Identity system .
Read More »