Re: Ghost index prevents DROP USER CASCADE

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 16 Jul 2003 22:54:29 GMT
Message-ID: <FIkRa.40$fL5.18@news02.roc.ny>

"Jorge Martin-de-Nicolas" <jorgemdn_at_yahoo.com> wrote in message news:626a83ff.0307161248.9acdc46_at_posting.google.com... ---snip--
> QUESTION
> ========
> How can I drop the user? Should I log in as "sys" or
> "system" and try to manually delete the "ghost" index
> from the DBA_OBJECTS table?
>
> Any help would be appreciated,
>
> Thanks,
>
> Jorge

Apart from what others have told you. If you can .. try bouncing the server and then try repeating the steps. Also: You might want to contact Oracle Support first.

Anurag Received on Wed Jul 16 2003 - 17:54:29 CDT