Originally posted by OracleDoc
A 30 gig index???!!! Dude that's insane! Ever heard of partitioning?
What if a unique index ( global nonpartitioned index ) is neccesaary for that partitioned table and that key/s is/are not a part of column/s on which table is partitioned?

Abhay.