Skip to Main Content
Forums

Oracle Database Discussions

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.

ORA-02243:invalid ALTER INDEX or ALTER MATERIALIZES VIEW option

seraphJul 12 2007 — edited Jul 12 2007

Hi, Friend,
I am changing all the index to another tablespace of one of my schema.When I run the DDL script,got the error:

ORA-02243:invalid ALTER INDEX or ALTER MATERIALIZES VIEW option
I checked the metalink, got nothing.Anyone can help? Thanks!

Comments

Satish Kandi
Could you post the command that you used to alter the index?
seraph

Hi, Statish,

My command is :

 ALTER INDEX abc REBUILD TABLESPACE abc_index;

Thanks!

seraph
I also googled some info,like:

Oracle Error :: ORA-02243

invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
Cause

An option other than INITRANS, MAXTRANS,or STORAGE is specified in an ALTER INDEX statement or in the USING INDEX clause of an ALTER MATERIALIZED VIEW statement.
Action

Specify only legal options.

But I still can't find the clue.
seraph
I am just wonder whether I should disable primary key constraint. Is that a problem to cause this error?
Satish Kandi
Looks like a bug. May be try raising an SR unless someone over here on forums has better ideas.
seraph
SR? How? Thanks!
Satish Kandi
http://www.ct.gov/doit/lib/doit/escalating_issues.doc
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 9 2007
Added on Jul 12 2007
#general-database-discussions
7 comments
10,517 views