Re: Problem dropping an index

> It doesn't give any errors. The session just hangs. During this time, even
> describing the table from other session doesn't work.
>

You need to find out what the session is waiting on - find out your session_id
from v$session and then from v$session_wait find out what is it waiting on. based on that - you can drill down further - at least if you post your results
from v$session_wait - we can probably assist. Received on Wed Jan 23 2002 - 23:25:05 CST