Drop an indextype.
Syntax:
DROP INDEXTYPE [schema.]indextype [FORCE]
FORCE will drop even if the
indextype is referenced by a domain index. In this case the index becomes invalid.
Related Oracle Commands:
INDEXTYPE - CREATE INDEXTYPE
INDEX - CREATE
INDEX
DBA_INDEXTYPES ALL_INDEXTYPES USER_INDEXTYPES
DBA_INDEXTYPE_OPERATORS ALL_INDEXTYPE_OPERATORS USER_INDEXTYPE_OPERATORS