Hello

Why recreate the index if you are on 8i try rebuliding the index instead..............as index revuilding is much faster .

regards
hrishy