Home » SQL & PL/SQL » SQL & PL/SQL » SQL * plus problem
SQL * plus problem [message #160047] Wed, 22 February 2006 23:54 Go to next message
mahesh.vadamudula
Messages: 7
Registered: February 2006
Location: vizag
Junior Member
Hi all,

On Windows i am running Oracle 9.2.0.1.0 version.
Here is my problem. I am not able to open the edit buffer.
and its showing following error code. So what to do.


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


Thank Q in advance.

Waiting For reply ASAP.

Re: SQL * plus problem [message #160061 is a reply to message #160047] Thu, 23 February 2006 00:44 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
right-click on the menu-item or the shortcut you use for starting sqlplus.
Choose Properties.
Change the "Start in" to a directory in which you have write-access. If this is already the case, check the file-properties of afiedt.buf in this directory; it is probably read-only.

hth
Re: SQL * plus problem [message #235392 is a reply to message #160061] Sat, 05 May 2007 08:29 Go to previous messageGo to next message
anamika901
Messages: 3
Registered: May 2007
Junior Member
Hello !

I get the following error when I use Run SQL Command Line in Oracle 10 Express edition.

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

Please help.

Thanks
Re: SQL * plus problem [message #235393 is a reply to message #235392] Sat, 05 May 2007 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start your SQL*Plus in a directory in which you have write access right.

Regards
Michel
Re: SQL * plus problem [message #235407 is a reply to message #235392] Sat, 05 May 2007 09:53 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
anamika901 wrote on Sat, 05 May 2007 15:29
Hello !

I get the following error when I use Run SQL Command Line in Oracle 10 Express edition.

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

Please help.

Thanks

Did you try what I suggested 15 the original poster 15 months ago??
Re: SQL * plus problem [message #235699 is a reply to message #160047] Mon, 07 May 2007 13:02 Go to previous messageGo to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

well ....... install windows and than install Oracle 10g rather than 9i ....... try that and tell me the result ...... ok
Re: SQL * plus problem [message #235704 is a reply to message #235699] Mon, 07 May 2007 13:29 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
eh?
Re: SQL * plus problem [message #235738 is a reply to message #235704] Mon, 07 May 2007 16:00 Go to previous messageGo to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

okay .... if you don't want that .... so do that - for example :-

SQL> select*from job_history;

EMPLOYEE_ID START_DAT END_DATE  JOB_ID     DEPARTMENT_ID
----------- --------- --------- ---------- -------------
        102 13-JAN-93 24-JUL-98 IT_PROG               60
        101 21-SEP-89 27-OCT-93 AC_ACCOUNT           110
        101 28-OCT-93 15-MAR-97 AC_MGR               110
        201 17-FEB-96 19-DEC-99 MK_REP                20
        114 24-MAR-98 31-DEC-99 ST_CLERK              50
        122 01-JAN-99 31-DEC-99 ST_CLERK              50
        200 17-SEP-87 17-JUN-93 AD_ASST               90
        176 24-MAR-98 31-DEC-98 SA_REP                80
        176 01-JAN-99 31-DEC-99 SA_MAN                80
        200 01-JUL-94 31-DEC-98 AC_ACCOUNT            90

10 rows selected.

SQL> save hh
Created file hh.sql


by this way the sql file hh.sql will save in this path:-

C:\oracle\product\10.2.0\db_1\BIN

and in anytime you want to edit the file ....

just enter to SQL*PLUS and write that :-

ed hh


and than the file will be edited .

that's all ...... and good luck

[mod-edit]removed the horrible [size=5] tag.

[Updated on: Tue, 08 May 2007 01:25] by Moderator

Report message to a moderator

Re: SQL * plus problem [message #235769 is a reply to message #235738] Tue, 08 May 2007 00:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use such big size and bold without a good reason.
This is very agressive.

Regards
Michel
Re: SQL * plus problem [message #235777 is a reply to message #235738] Tue, 08 May 2007 00:20 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Hany thought it would be wise to scream
and than the file will be edited .

that's all ...... and good luck

...
Which has nothing to do with his problem...
Re: SQL * plus problem [message #235938 is a reply to message #160047] Tue, 08 May 2007 08:20 Go to previous messageGo to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

thanks anyway ...... and that all what I have to solve this problem

[Updated on: Tue, 08 May 2007 12:22] by Moderator

Report message to a moderator

Re: SQL * plus problem [message #235947 is a reply to message #235938] Tue, 08 May 2007 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

DON'T USE SUCH FONT SIZE IT IS AGRESSIVE.

./fa/1579/0/./fa/1579/0/./fa/1579/0/./fa/1579/0/./fa/1579/0/./fa/1579/0/./fa/1579/0/./fa/1579/0/./fa/1579/0/./fa/1579/0/

Use default unless you have a good reason.
And the level of your answers is not this one.

Regards
Michel
Re: SQL * plus problem [message #235960 is a reply to message #235947] Tue, 08 May 2007 09:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, what I said is not from rules (afaik) it is just common sense.
See all posts.
Everybody use default font unless there is a good reason: emphasis for instance.

Yes, your posts are agressive. They hurt my eyes.
See above, moderator already modified one of your previous post to turn it into something more friendly.
This is a technical forum, you don't need to flash your post.

Regards
Michel

[Updated on: Tue, 08 May 2007 23:44]

Report message to a moderator

Re: SQL * plus problem [message #236052 is a reply to message #160047] Tue, 08 May 2007 16:15 Go to previous message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

ok ...... I see ....... all right
Previous Topic: quary displaying hiredates?
Next Topic: CURSORS
Goto Forum:
  


Current Time: Sat Dec 10 18:44:37 CST 2016

Total time taken to generate the page: 0.09917 seconds