Database DataWarehousing (MOSC)

MOSC Banner

alter table rebuild invalid indices

edited Feb 3, 2010 5:06AM in Database DataWarehousing (MOSC) 18 commentsAnswered
Hello. I am running alter table rebuild invalid indices in 10.2.0.3 against a partition with 150mil to 200mil rows. The table is partitioned 8 ways and the three indices on it are partitioned 12 ways, but I don't think the process is running in parallel. I don't see parallel slaves anywhere. IS this the 'feature' of this command or is there something that I am missing?

thank you

gene 

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