Re: why is my query editor and command line out of sync?

genericax_at_hotmail.com (Sara) wrote in message news:<776e0325.0112061049.228f92c9_at_posting.google.com>...
> I'm in sqlplus, and I enter a query then execute it. Then I type
> "edit" and the query the pops up in the editor isn't the one I just
> used.
>
> Also, when I exit the editor, and press "/-ret", it executes the
> previous sql command that I typed at the sqlplus prompt. It totally
> ignores what I just created in the editor.
>
> mysql up-arrow to retrieve and edit sql commands is about 1000 times
> easier than this, and the fact that it WORKS is nice too...
>
> GX

You didn't say what platform you are on, because it probably will make a difference. I would guess you have a file with the same as the one Oracle is trying to create, owned by someone else (perhaps you are the owner, but Oracle is the user trying to change this file). Look for a file named something like afiedt.buf in your default or current working directory.

jg

--
"The sand isn't gone, it's just hiding" - SANDAG spokesman, explaining
what happened to half sand on the beach, expensively dredged there
just before the largest 72 hour set of swells in years.
http://www.garry.to