Saturday 1 April 2017

DISABLE and ENABLE an INDEX in Oracle

Please use the below commands to Disable or Enable Index in Oracle.

Disabling an Index :-

ALTER INDEX SCHEMA_NAME.INDEX_NAME UNUSABLE
/

Enabling an Index :-

ALTER INDEX SCHEMA_NAME.INDEX_NAME REBUILD
/

No comments:

Post a Comment