Problem with disabling an index
592091Oct 13 2008 — edited Oct 13 2008Hi All,
I have defined a unique index on table tmp columns (a,b)
Below is the table structure.
desc tmp
Name Null? Type
----------------------------------------- -------- ----------------------------
A NUMBER
B NUMBER
The table is having some data. I am trying to update the data which is causing a unique key violation.
When I tried to disable the index using below command
alter index tmp_idx disable;
it throwed an error
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
Also, I tried making the index unusable and SKIP_UNUSABLE_INDEXES = true at session level but no luck.
Oracle version used by me is 11g.
I have 2 doubts:
1] Why did disabling index throw an error
2] Is there any other option available other than droping the unique index.
Rgds,
Amol
Edited by: amolpatre on Oct 14, 2008 10:42 AM