Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding new partition causes invalid index ?

662384Dec 29 2008 — edited Jan 4 2009
Hi,

I' am on 10gr1.I have an huge table which is month partitoned on date column.For this new year i have to add new partitions.
So I wonder,Adding a new partition on a partitioned table causes invalid index.Must i rebuild index after this adding process.

Thanks in advice.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 1 2009
Added on Dec 29 2008
#general-database-discussions, #index
8 comments
2,606 views