Ltd. There is the potential for conflict if you and another user happen to be sharing the same current working directory, and you both invoke an external editor to edit the contents Like Show 0 Likes(0) Actions 23. Learn In Hindi 8,814 views 2:12 ORACLE 11G INSTALLATION ON WINDOWS - Duration: 10:34.
Tick Mark It. SQL*Plus in window #2 reads back the same statement that it wrote out.
Closed window #1's Notepad instance. TechTutorialVideo 236,338 views 8:42 How to fix solve Windows cannot access the specified device, path, or file error - Duration: 4:04. 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
Thank you soooo much....I tried a lot...but only yours is very simple and worked for me easily....Thanks a lot again.. Example 2-16 shows a query being entered and the editor being invoked. Red Hat 6 RHEL Installation How to Install SQL Server 2008 - A Step by Step Gu... Now, type ed or edit command and hit Enter key of your keyboard.
Then Run the SQL PLUS ... Powered by Blogger. The name is a throwback to the very early days of SQL*Plus when it was briefly known as AFI, which stood for Advanced Friendly Interface. his explanation Save the file double click on file.
you are probably using the old ed editor which you can quit by entering the q command (see its guide with man ed). news Here are some rules to follow when editing the SQL buffer with an external text editor: Do not end SQL statements with a semicolon. End PL/SQL blocks with a semicolon. Report message to a moderator Re: SP2-0111: Cannot close save file "afiedt.buf" [message #649581 is a reply to message #649577] Thu, 31 March 2016 05:57 Michel Cadot Messages:
asked 1 year ago viewed 5038 times active 1 year ago Visit Chat Related 751How to effectively work with multiple files in Vim?23How to find out when a particular table was Re: SP2-0110: Cannot create save file "afiedt.buf" 981654 Dec 26, 2012 6:42 AM (in response to 690937) it is ok thanks alot from your help Like Show 0 Likes(0) Actions 26. Handy SQL*Plus setup guide Do NOT "solve" the problem by changing the permissions as suggested above. have a peek at these guys March 1, 2014 at 8:37 PM Shahid ul Ghani said... \app\Administrator\product\11.2.0\dbhome_1\BINYou can find sqlplus from the above directory in oracle 11g March 11, 2014 at 2:51 AM Zaro Aspi said...
Thank you again. have u got any solution for this?? Please enter a title.
SP2-0110: Cannot create save file "afiedt.buf" if i want to change my directory where can i find that, how can i change can you please tell me, thanks.
The following EDIT command, for example, lets you edit your Unix profile: EDIT .profile When you edit a file in this way, the contents of the file are not loaded into The filename afiedt.buf is passed as the first argument in the editor's invocation (e.g., vi afiedt.buf , or Notepad afiedt.buf ). This is just a convenient way for you to edit a file without having to exit SQL*Plus first. thnx bro..ReplyDeleteTariq Ali KhanFriday, December 12, 2014 8:39:00 amgood..
Home Computers & Technology Home Computing Business & Culture Programming Software Web Development Certification Networking Security & Encryption Computer Science Operating Systems Microsoft Hardware Databases Graphic Design Apple Digital Music Digital sreetheja amilineni 2,127 views 3:33 41. Try and enjoy! check my blog solved ► 2011 (1) ► September (1) ► 2010 (5) ► September (1) ► July (1) ► March (1) ► February (1) ► January (1) ► 2009 (13) ► November (2)
Not quite as handy as before the Helpdesk did their magic, but barely acceptable. total 8 drwx------. 25 olaf olaf 4096 Mar 30 19:10 olaf drwx------. 30 oracle oinstall 4096 Mar 31 18:40 oracle Dear Michel ps -ef | grep afiedt.buf oracle 6977 6936 0 more I love to dive in data like a dolphin! That's what the documentation also says.Except our laptops have few administrative privileges.
Re: SP2-0110: Cannot create save file "afiedt.buf" William Robertson Jul 27, 2010 6:15 PM (in response to 783882) your file afiedt.buf is somehow currupt. For example, the installation location of Oracle 10g is G:\oracle\product\10.2.0\db_1\bin in our computer. Re: SP2-0110: Cannot create save file "afiedt.buf" Chenna Oct 23, 2009 8:20 PM (in response to 589652) Hi, You will get the error because you will not have the access to Join the community to create your free profile today.
Figure 2-6. Tick Mark It. Hats Off to you. How Migrate All Files on ASM to Non-ASM (Unix/Linu...
you wrote to find the sqlplusw.exe. Re: SP2-0110: Cannot create save file "afiedt.buf" sb92075 Dec 26, 2012 6:46 AM (in response to 981654) why respond to a 2 year old thread? Does sputtering butter mean that water is present? Watch QueueQueueWatch QueueQueue Remove allDisconnect Loading...
This is what I have in mind: A typical /etc/passwd file entry looks something like this: rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin User rpc has uid=32 and group=32.