kunal1017

 Profile Answers by kunal1017 

• Aug 28th, 2008

 

When you perform DDL commands on a partition table then you should use UPDATE GLOBAL INDEXES clause.

GLOBAL INDEXES are different from LOCAL INDEXES.

Local Indexes are the indexes on partitions of table partition vise. So performing DDL on partitions automatically updates local indexes. Thus if we drop one partition of a table then the corresponding local index is also dropped.

But its not the case with GLOBAL INDXES. A global index is an index which can have the index entry for any partition of a table. So when performing DDL on table we need to update the GLOBAL index by using UPDATE GLOBAL INDEXES clause.