Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disable the index in oracle

317546Feb 18 2008 — edited Feb 2 2012
Hi,

Is there any way we can disbal the index in oracle.
For the performance issue,I want to disable some of the indexes which i have created earlier. I dont want to drop the index.

I tried the below command
Alter Index <Schema>.<Index_name> Disable;

I am getting the below error message:
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option


Thanks,
Krishna
.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2012
Added on Feb 18 2008
11 comments
183,662 views