Ora-02429 cannot drop index used for enforcement of unique/primary key
557935May 29 2007 — edited May 29 2007Dear All,
The scenario is like this prev i had one single tablespace which had all the tables , now i have created separate tablespaces and have grouped the tables accordingly. Now the Single Tablespace is empty as i have moved all the tables to other tablespaces , now when i am dropping that tablespace i am getting this error.
Ora-02429 cannot drop index used for enforcement of unique/primary key
I dont understand what to do as the reason on the Forums is stating
drop the constraint instead of the index.
I dont understand the meaning of this statement can anybody be more clear on this
Plz reply as it is vry urgent.
Regards
Apoorva