Zhu: This is a quite known issue (bug?). You may have to contact support for the workaround (that is just updating the IND$.STATUS) or wait for the cleanup. Typically restarting cleansup the IND$, or you need to update the dictionary at restricted mode. --- Best Regards, K Gopalakrishnan=20 Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/ -- //www.freelists.org/webpage/oracle-l