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
/
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