Oracle Error Sp2-0110
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. sp2-0110 cannot create save file afiedt.buf in oracle 10g Please enter a title. You can not post a blank message. Please how to use ed in sqlplus type your message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL afiedt.buf means This discussion is archived 1 2 Previous Next 28 Replies Latest reply on Mar 30, 2013 12:40 PM by 1000114 Go to original post This content has been marked
How To Use Notepad In Sqlplus
as final. Show 28 replies 15. Re: SP2-0110: Cannot create save file "afiedt.buf" 598644 Sep 18, 2007 7:51 PM (in response to 598644) i have fixed the problem.I created a folder named "sql" inside oracle that is, c:\oracle\sql then i went to sql*plus shortcut,right clicked and went to properties.....there i changed the start in as c:\oracle\sql now i m afiedt.buf location able to open afiedt.buf...thanks for ur cooperation!! Like Show 0 Likes(0) Actions 16. Re: SP2-0110: Cannot create save file "afiedt.buf" William Robertson Sep 18, 2007 11:19 PM (in response to 598644) Glad to hear it's working now. > I'm new to Windows vista and oracle 10g I've never used Vista. Good to know shortcut properties are the same as in all the previous versions ;) Like Show 0 Likes(0) Actions 17. Re: SP2-0110: Cannot create save file "afiedt.buf" 690937 Mar 14, 2009 11:29 AM (in response to William Robertson) There is a very simple Way of Getting Rid of this error and that is .... 1> Right click on the shortcut of SQL Plus . 2>There You will see ADVANCED. Click on it .. 3>There is an option Run As Administrator . Tick Mark It. Then OK, Ok . Then Run the SQL PLUS ... This is the solution to Your Problem ... I am greatful to help Every One ..... Like Show 1 Likes(1) Actions 18. Re: SP2-0110: Cannot create save file "afiedt.buf" William Rober
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube edit command in oracle εμφανίζεται στα Ελληνικά. Μπορείτε να αλλάξετε
Sql Notepad Editor
αυτή την προτίμηση παρακάτω. Learn more You're viewing YouTube
Ed Command In Oracle 11g
in Greek. You can change this preference below. Κλείσιμο Ναι, θέλω να τη κρατήσω https://community.oracle.com/thread/546846?start=15&tstart=0 Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ How to resolve SP2-0110: Cannot create save file "afiedt.buf"" Error? https://www.youtube.com/watch?v=VEmMSPaQCw4 radhikaravikumar ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής7.0837 χιλ. Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση Μεταγραφή Στατιστικά στοιχεία 1.712 προβολές 11 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 12 0 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 1 Φόρτωση... Φόρτωση... Μεταγραφή Δεν ήταν δυνατή η φόρτωσ
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project http://it.toolbox.com/blogs/data-ruminations/i-didnt-know-sp20110-cannot-create-save-file-afiedtbuf-53939 and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking http://howtoinoracle.blogspot.com/2011/06/solution-of-sp2-0110-cannot-create-save.html SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard in oracle iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Data Warehouse Blogs I Didn't Know: SP2-0110: Cannot create save file "afiedt.buf" Duke Ganote Nov 19, 2012 | Comments (0) Tweet 0 Please Sign In how to use or Register to like this blog. Everyone has their preferred toolset for working in the database. One of my co-workers just logs into our AIX server and uses vi. I tend to use the client-side, character-based SQL*PLUS on my Windows laptop. Until this week, No problem. Comfortable. I only had one database of our many databases (and that database was only created a month ago) where I would log in and see this when I tried to edit a comment: SQL> ed SP2-0110: Cannot create save file "afiedt.buf" SP2-0110. Arg! No editing. When I needed to work on that particular database over the past few weeks,I "worked around" the issue -- I just pasted my SQL directly into the SQL*PLUS session . HOWEVER, a couple of days back I called our corporate helpdesk on an unrelated issue. The helpdesk remotely logged onto my laptop, deleted all the temporary internet files, and did a few other things. None of which solved
computer, you would like to practice the Oracle SQL in Oracle SQL*Plus. Definitely you can do it but sometimes you mistake to write the full command correctly. But what do you do? Generally you would like to use the ed or edit command from the Oracle SQL*Plus prompt and like to correct the errors of your SQL syntax. But you can not do. You are getting the error message like SP2-0110: Cannot create save file "afiedt.buf". Most people, who are using Oracle in Windows 7 operating system, get this error message firstly. But how to solve it. Hopefully, you already searched lots of place for the solution of this. You may get lots of articles or lots of documents to solve this simple error but you could not solve the error totally. The good news is that, you will find the complete and easy solution here to solve the problem or error SP2-0110: Cannot create save file "afiedt.buf" in the following paragraphs. The cause of of the error SP2-0110: Cannot create save file "afiedt.buf" occurs due to the problem of Oracle installation destination or directory permission . But this can be easily solved following the mentioned steps: Create a folder in any place of your computer. For example, we create a folder in G directory and named it as MyOracle folder. Go to the Oracle installation directory and browse through the bin directory to find out the sqlplusw file. For example, the installation location of Oracle 10g is G:\oracle\product\10.2.0\db_1\bin in our computer. So, we have to go there and find out sqlplusw file. Now, copy a shortcut of this file and copy the shortcut and past it to the folder which we created in step 1. Let's try this by double clicking and type the sql commands. Now, type ed or edit command and hit Enter key of your keyboard. What you are seeing? Is there any error? No error at all and