Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can't drop Index on empty table - ORA-02429

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

From: N <nickel10b_at_hotmail.com>
Date: 7 Jan 2002 09:54:18 -0800
Message-ID: <77c198f0.0201070954.3960f740@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 - 11:54:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US