Database DataWarehousing (MOSC)

MOSC Banner

Unusable partition index

edited Jul 21, 2015 11:10PM in Database DataWarehousing (MOSC) 3 commentsAnswered

I've few questions related to global partition indexes.

1.For internal partition which are being added everyday do we need to update indexes for that.

2. We've a custom created package to drop few partition's as part of business needs. We're are dropping few partitions for ex:

   alter table <table_name> drop partition p1;

   alter table <table_name> drop partition p2;

   alter table <table_name> drop partition p3 update global indexes;

if we do it directly through commands our index will be in a valid state where as if we do it through package our index will be in unusable state.

I'm not able to understand why its behaving like that .

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