Rafiq, Regarding your comment...
The issue is always using parallel caluse on a index with multiple keys. Single key indexses has no issues.Do you mean to say that the PARALLEL clause in CREATE | ALTER INDEX is somehow affected by the number of columns or expressions specified in the index? Can you elaborate or substantiate?
Thanks! -Tim -- //www.freelists.org/webpage/oracle-l