Problem dropping an index

Hi,

As part of our daily extract exercise, we drop index on a table (say table A) , insert data into the table and then recreate the index back. The process stopped today at the step where it was trying to drop the index. It gave no error or anything. I killed the session before which it ran for several hours. During the time that session was running, even a describe on that table A won't work. After killing that session, I tried dropping that index again, which didn't work.

I checked up in v$session and v$locked_objects and found that no session is holding any locks on the table. I also queried the v$sqltext view to find out any sql statement which could be using that index, thinking that if any object is using that index, oracle won't allow the index to be dropped. But I couldn't find any query which could be using that index.

Any pointers/help would be very much appreciated ... ORACLE version is Oracle8i Enterprise Edition Release 8.1.7.2.0 .

Thx,
Nasir Received on Wed Jan 23 2002 - 14:11:40 CST