Re: Can't drop Index on empty table - ORA-02429

As the index you are trying to drop is the primary/unique key of the table you will need to remove it with the alter table command. I believe Oracle probably implement them in this way to stop you mistakenly dropping unique/primary keys. You should probably read up on constraints in the Oracle Documentation so you understand what you are dealing with.

Kind Regards

Fraser McCallum
MVP Oracle
www.brainbench.com

"N" <nickel10b_at_hotmail.com> wrote in message news:77c198f0.0201070952.5f4ee247_at_posting.google.com...
> I'm beginning work on an Oracle table that was created by someone
> else. The table has not been used yet, and has no data in it. It has
> a unique index on it which is a combination of 4 columns. I'd like to
> remove one of the four and replace it with a different column.
>
> I'm unable to alter the index, perhaps because of syntax issues. When
> I tried to drop the index to start over, I got this message:
>
> ORA-02429: cannot drop index used for enforcement of unique/primary
> key
>
> What can I do to get around this? Thanks.
Received on Mon Jan 07 2002 - 12:27:28 CST