Re: Global Index on Partition Table

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: Kellyn Pedersen <kjped1313@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 30 Oct 2009 09:57:10 -0700 (PDT)

Thanks Kellyn for the update. What I understood is that if it is UNIQUE index, 
it will still VALIDATE even I add WITHOUT Validate it. Am I coorect with my 
assumption here.

Not Clear what is significance of VALIDATION portion. Does this impact on 
existing Index that can have some fragmention in the future and need to be 


From: Kellyn Pedersen <kjped1313@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx; smishra_97@xxxxxxxxx
Sent: Fri, October 30, 2009 12:22:17 PM
Subject: Re: Global Index on Partition Table

Hopefully I'm understanding your question completely, but yes, with the 
partition maintenance, if you are exchanging partitions, then you do need to 
update the indexes as well or they will become unusable...
Are you looking if you need validation or not or if you need to rebuild them?  
That's what I can't tell if you are questioning...

Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.

"Go away before I replace you with a very small and efficient shell script..."

--- On Fri, 10/30/09, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:

>From: Sanjay Mishra <smishra_97@xxxxxxxxx>
>Subject: Global Index on Partition Table
>To: oracle-l@xxxxxxxxxxxxx
>Date: Friday, October 30, 2009, 10:04 AM
>I had 2 Tb table with Quarterly Partition and has 5 Global index. When we are 
>doing quarterly maintenance and exchanging the partition  we are using the 
>As two of them are Unique index and so I think VALIDATION is anyway done. 
>Question is that how it impact the Indexes ? Do I really need to Rebuild the 
>index in the future or it is fine. 
>Actually Earlier partition maintenance are not done with above clause leaving 
>Index in Unusable state but adding the above will avoid this and save downtime 
>which is big due to several big indexes as well as DB in LOGGING mode due to 
>Standby database.


Other related posts: