Sorry, more question abotu partitions.
I noticed the globla index on partitioned table was buggered after I split a partition.
Should I disable the global index before I split any partitions?
Printable View
Sorry, more question abotu partitions.
I noticed the globla index on partitioned table was buggered after I split a partition.
Should I disable the global index before I split any partitions?
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...