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