Database DataWarehousing (MOSC)

MOSC Banner

Adding new partition causes invalid index ?

edited Jan 20, 2010 8:02AM in Database DataWarehousing (MOSC) 4 comments
Hi,
I' am on 10gr1.I have an huge table which is month partitioned table on date column.For this new year i have to add new  partitions.
This process will be done first time.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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center