hi,

before indexing you can set the
"sort_area_size"
parameter to a higher value.

oracle will use this area for sorting while indexing.

once your indexing is over then reduce it back.

some version of oracle (eg.oracle 8i standard edition)
will not support parallel dml.

it will just ignore your parallel clause.



- Raja