ora 54 resource busy

[hrishy]

Hi

I am using sql based inserts and not a direct part insert.But its a bulk insert uisng Pro *C array features.

I did not understand about the skip unusable indexes=true.How do i do that ?

And also the ora 54 occurs when i am trying to set the parallel degree for the index not when i am rebuilding the index.

Do you mean something like

alter session set skip_unusable_indexes=true;
alter index myindex unusable;
alter index myindex rebuild;

regards
Hrishy

regards
Hrishy