Oracle Database Administration: The Essential Refe

Name

DROP INDEX

Synopsis

DROP INDEX
[schema.]index_name

Removes an index (index_name) from the database.

Note

The index to be dropped must be in your schema, or you must have the DROP ANY INDEX privilege to remove an object from another schema.

Example

The following example removes the index empno_ndx from scott’s schema in the database. When an index is dropped, all of the space it previously occupied is returned to the free space pool:

DROP INDEX scott.empno_ndx