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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
182,633 views