Monday, June 18, 2012

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

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.

9 comments:

  1. Thanks for your post. I have tried and read for hours to solve this problem: Oracle forum, Dba forums.
    You were of great help indeed!

    ReplyDelete
  2. Superb,
    You 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

    ReplyDelete
  3. sp2-0110 cannot create save file afiedt.buf IN ORACLE 11G ON WINDOWS 7

    ReplyDelete
  4. fantastic.. answer to the point.. its of great use.. thankX a lot

    ReplyDelete
  5. thanks a lot bro

    ReplyDelete
  6. Hi Manish.... Thanks Thanks alot..

    i 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...

    :-)

    ReplyDelete
  7. very good and easy solution.Thanks

    ReplyDelete
  8. SQL>set editfile d:/sqledit.sql

    ReplyDelete

web stats