I had dropped a table which had a primary key index. When I recovered it using flashback, the table got recovered. Primary key has also been recovered but with the name BIN$Hyx0mxWUJUHgRAADul0Z8w==$0. Now, when I see the status in user_indexes, it shows unusable.
If i try to drop this index using the command
drop index BIN$Hyx0mxWUJUHgRAADul0Z8w==$0, it gives an error.
I even tried dropping it using :
alter table emp drop constraint BIN$Hyx0mxWUJUHgRAADul0Z8w==$0
But this also does not work.
My problem is that I want to remove it and create a new primary key on my table. Please tell me how to solve this problem.