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!

Unable to disable an index

317179Oct 10 2002

I am trying to disable an index... using the statement "ALTER INDEX <NAME> DISABLE". However i consistently get the following error: ORA-02243: invalid ALTER INDEX ... option. The only thing is i cannot figure out why. According to the doc, ALTER INDEX <NAME> DISABLE is a perfectly valid statement.
I have INDEX rights on all the tables involved.
Can anyone please explain to me how you are supposed to disable/enable an index? Thanks in advance,
Aaron. aabdis @ mecnet . com

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2002

Added on Oct 10 2002

7 comments

1,470 views