In my program I will insert a lot of data into the tables (Oracle). In order to speed up the processing, I am going to use DROP INDEX before insert the data and then CREATE index. But as I want to drop the index, such as DROP INDEX PARTNERID or DROP INDEX SYS_C00831, it failed. It comes an error message like:
ORA-02429: Index to forced unique/primarykey not deletebly.