Re: Problem creating indexes using parallel query

"Tim Nickason" <tnickasn_at_axionet.com> wrote:

>I'm having a problem when creating a second segmented index on a table and
>using parallel query at the same time. The create index appears to work
>okay (No ora errors , nothing unusual in alert or trace files) however
>the create takes along time and when complete further inspect of the index
>shows that ther are no 'leaf blocks'.

...

What if you were to create it once with the parallel 1, then perform a rebuild with 'unrecoverable'? The syntax should be something like,

    ALTER INDEX ... REBUILD UNRECOVERABLE. You might also need to tone-down the parallelism to say, two instead of four. Who knows, maybe Oracle is getting way confused with too many parallel processes trying to do the same thing.

• Doug Anderson Oracle Database Administrator DAtheDBA_at_mindspring.com