ora 54 resource busy

[slimdave]

How about a different approach, of setting the index unusable, "alter session set skip_unusable_indexes=true", load, then rebuild the indexes? I find it more robust myself, as changes to index properties (tablespace etc) do not have to be stored outside of the existing index definition.

Are you using direct-path loads, by the way? If so, have you evaluated loading with enabled indexes in place? If not, I would strongly advise that you use direct and not conventional-path inserts

[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