How to make index unusable and then rebuilt in index

Question

I have one function that insert thousands of records into table I want to unusable index at that time and then I am processing on that data data so I want to rebuilt that index again.

Is it possible in Oracle?

Answer 1

alter index idx_name unusable;

alter index idx_name rebuild;

but it is possible that you'll need:

drop index idx_name

create [unique] index idx_name ...