Database DataWarehousing (MOSC)

MOSC Banner

New Feature unusable Index-Partitions: is there any risk to use this feature?

edited Dec 26, 2013 8:43PM in Database DataWarehousing (MOSC) 6 commentsAnswered
Oracle-Version 11.2.0.3.PSU5 on aix 6.1

Problem description: we have a hugh table with partitions based on month for 10 years. For a new application we need a nonunique new local index but only for the last 12 months. Older partitions will be ignored by the application. My idea: I create an unusable locacl index and rebuild only the last 12 months partitions of the index, this saves a lot of space.

My Question: We have no experiances with such an index, is there any risk to work with unusable index partitions?

Many thanks for any answer,

Brigitte Türk

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