How to delete a unique index in oracle
The first step is to delete the connection between the table and the index
ALTER TABLE TABLENAME DROP CONSTRAINT PK_TABLENAME ;
The second step is to execute the delete index statement
DROP INDEX PK_TABLENAME ;
The third step is to re-create the index.
create unique index PK_TABLENAME on TABLENAME (ID,NAME);
Recommended tutorial: "Oracle Tutorial"
The above is the detailed content of How to delete unique index in oracle. For more information, please follow other related articles on the PHP Chinese website!