Oracle Error Message
ORA-29832: cannot drop or replace an indextype with dependent indexes
Reason for the Error
One or more indexes are dependent upon the indextype.
Solution
Drop all the indexes which are dependent upon the indextype before dropping the indextype itself.