|Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
CREATE SYNONYM to DROP ROLLBACK SEGMENT, 19 of 31
INDEX statement to remove an index or domain index from the database.
The index must be in your own schema or you must have the
INDEX system privilege.
Specify the schema containing the index. If you omit
schema, Oracle assumes the index is in your own schema.
Specify the name of the index to be dropped. When the index is dropped, all data blocks allocated to the index are returned to the index's tablespace.
If you drop a domain index:
FORCEclause and removes the user-defined statistics collected with the statistics type.
If you drop a global partitioned index, a range-partitioned, or a hash-partitioned index, all the index partitions are also dropped. If you drop a a composite-partitioned index, all the index partitions and subpartitions are also dropped.
FORCE applies only to domain indexes. This clause drops the domain index even if the indextype routine invocation returns an error or the index is marked
FORCE, you cannot drop a domain index if its indextype routine invocation returns an error or the index is marked
This statement drops an index named