A global index will become UNUSABLE when you modify the underlying partitions (In Oracle 8i, anyway). See http://otn.oracle.com/docs/products/...rti.htm#430605 for details...