Application Express User's Guide > Managing Database Objects w... > Managing Indexes > Dropping an Index
To drop an index:
On the Database Home Page, click the Object Browser icon.
Object Browser appears.
From the Object list, select Indexes.
From the Object Selection pane, select an index.
Under Object Details, click the Drop tab.