Database DataWarehousing (MOSC)

MOSC Banner

Dropping Partitions causes invalid Indexes

edited Mar 22, 2010 4:25AM in Database DataWarehousing (MOSC) 1 commentAnswered
 Hi,

We are testing partitioning on large tables for cleanup purposes and when we drop an old partition, the indexes for that table become unusable. How can I prevent this ?

Jeff

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