|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 15 of 26
INDEXTYPE statement to drop an indextype, as well as any association with a statistics type.
CREATE INDEXTYPE for more information on indextypes
The indextype must be in your own schema or you must have the
INDEXTYPE system privilege.
Specify the schema containing the indextype. If you omit schema, Oracle assumes the indextype is in your own schema.
Specify the name of the indextype to be dropped.
If any statistics types have been associated with indextype, Oracle disassociates the statistics type from the indextype and drops any statistics that have been collected using the statistics type.
FORCE to drop the indextype even if the indextype is currently being referenced by one or more domain indexes. Oracle marks those domain indexes
FORCE, you cannot drop an indextype if any domain indexes reference the indextype.
The following statement drops the indextype
textindextype and marks
INVALID any domain indexes defined on this indextype: