This blog show how to disable an index in a table using Alter command

Syntax:

ALTER INDEX index_name ON
table_or_view_name DISABLE


Example:

ALTER INDEX emppkind ON
emptable DISABLE