| alter index problem [message #173763] |
Wed, 24 May 2006 06:21  |
deepak samal
Messages: 29
Registered: February 2005
|
Junior Member |
|
|
i want to alter a index to Disable . i got the syntax as
ALTER INDEX INDEX_NAME DISABLE .
but this is not working . i am getting the error as
(ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option)
can you please help me how to disable a index .
|
|
|
|
| Re: alter index problem [message #173766 is a reply to message #173763] |
Wed, 24 May 2006 06:29  |
 |
Littlefoot
Messages: 21822
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Index can not be disabled; drop it instead.
[EDIT]
Did you, perhaps, mix terms "index" and "constraint"? If there's, for example, a primary key constraint and index on this column, you could disable primary key constraint, but index should be dropped.
[Updated on: Wed, 24 May 2006 06:32] Report message to a moderator |
|
|
|
|
|
| Re: alter index problem [message #173884 is a reply to message #173777] |
Thu, 25 May 2006 01:47 |
deepak samal
Messages: 29
Registered: February 2005
|
Junior Member |
|
|
thanks for this . this is working . but again i am not able to make this active , after giving the comand unusable .
after setting the "alter index myindex unusable", how can i make this enabled .
regards
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
