Home » SQL & PL/SQL » Client Tools » How to define ED command in sql*plus? (Oracle 11g,windows 7)
How to define ED command in sql*plus? [message #561843] Wed, 25 July 2012 12:29 Go to next message
sainathreddy
Messages: 1
Registered: July 2012
Location: HYDERABAD
Junior Member
In my sql*plus when i am writing the command ed .It was showing the error as
SQL> ed
SP2-0110: Cannot create save file "afiedt.buf"

i tried to define the editor by using the command define_editor=notepad;
But still my problem was not solved....
Please anyone can help me..
Re: How to define ED command in sql*plus? [message #561844 is a reply to message #561843] Wed, 25 July 2012 12:38 Go to previous messageGo to next message
BlackSwan
Messages: 23151
Registered: January 2009
Senior Member
Problem results when OS user does not have write permission to write file (afiedt.buf) to the current directory.
the solution is to invoke sqlplus only from any directory where current OS user can create a new file.
Re: How to define ED command in sql*plus? [message #561845 is a reply to message #561843] Wed, 25 July 2012 12:39 Go to previous message
joy_division
Messages: 4559
Registered: February 2005
Location: East Coast USA
Senior Member
The problem is not with the edit command but the fact that an afiedt.buf cannot be created in your current directory. You do not have "write" rights.
Previous Topic: unable to paste header(column) names result to excel
Next Topic: why below script showing lots of error & Which one is better for practise (merged by MC)
Goto Forum:
  


Current Time: Sat Dec 20 06:58:59 CST 2014

Total time taken to generate the page: 0.10594 seconds