Subject Re: Error "Index Unexpected deleted"
Author Aage Johansen
On Fri, 14 Nov 2003 08:47:52 +0000 (UTC), Chooi-Ting wrote:

> While application updating/inserting to the database, I inactivate one of
> the index key by using command alter index inactive. Error occurred in my
> application with this error "-901: index unexpected deleted". What does
> it mean ? Why inactivate an index key will cause this error ? Does it
> harmful to the database ?


Maybe your application used prepared SQL statements that included the index
you dropped. This might well confuse the db engine.
Harmful? Maybe not, but some validation may be a good thing.


--
Aage J.