Oracle 8: DROP INDEX

From: cristian <cristian_at_senior.com.br>
Date: Mon, 24 May 1999 17:51:46 -0300
Message-ID: <7ice8c$3aa$1@srv4-poa.nutecnet.com.br>

The following mistake happens when I try to turn off an index in Oracle 8.0.4:
"ORA-02429: cannot drop index used for enforcement of unique/primary key”. However that mistake only happens when happened the following situation:

CREATE TABLE TESTEINDICE (COL1 NUMBER(4,0) NOT NULL, COL2 NUMBER(4,0) NOT NULL, COL3 NUMBER(4,0) NOT NULL) / CREATE UNIQUE INDEX TESTEINDICEIndice2 ON TESTEINDICE (COL1,COL2) /

ALTER TABLE TESTEINDICE ADD(PRIMARY KEY (COL2,COL1)) / DROP INDEX TESTEINDICEIndice2 /
When executing this command the mistake it happens. If I turn off the primary Key the index it disappears, to the you create again it the index it reappears with other name. To create the primary key first and only later the index that mistake doesn't happen.

How do I do to turn off this index? Received on Mon May 24 1999 - 15:51:46 CDT