Re: Ghost index prevents DROP USER CASCADE

On Wed, 16 Jul 2003 23:05:56 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>> -----------------------------------------------------
>> SQL> drop user testcolo cascade;
>> drop user testcolo cascade
>> *
>> ERROR at line 1:
>> ORA-00604: error occurred at recursive SQL level 1
>> ORA-01418: specified index does not exist
>>
>> -----------------------------------------------------
>
>Looking at the name of the index, it is either a primary or an unique key
>constraint. To drop those indexes, you'll need to drop the constraint by
>using alter table drop constraint <constraint_name>. Dba_constraints will
>show the associated table.

 If that were the case, he'd get 'ORA-02429: cannot drop index used for enforcement of unique/primary key', not 'ORA-01418 specified index does not exist'.

>You can drop an user by issuing
>drop user <username> cascade.

 See above. That was the statement that initially caused the problem. You can't drop the user when hitting this problem.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)