Hello, I am a newbie at Oracle 10g. I am learning the Oracle 10g technology. Recently I have installed Oracle 10g in my Windows 7 Home Premium PC and started practicing on it. I can connect to hr user easily. I can work fine using the SQL *Plus and there is no problem with edit command in SQL *PLus because I set the write access to the bin folder in the directory, D:\Oracle\product\10.2.0\db_1\bin where my Oracle database is installed.
But, I prefer to work on Command Mode. The problem is that I can not use the edit command in the Cmd Mode. When I write the edit command and hit enter, there opens the notepad and shows the message, "Cannot find the afiedt.buf file. Do you want to create a new file? Yes, No Cancel"
My experience says, If once "yes" selected, the edit command then saves the afiedt.buf file permanently and returns the same saved SQL statement whenever the edit command is entered later (That's what happened to my lab PC). I have searched for the solution to this problem and found nothing in Google. Can anyone help me!