Re: ALTER TABLE modify partition rebuild unusable local indexes does not run in parallel - Thank you
From: <genegurevich_at_discover.com>
Date: Thu, 28 Jan 2010 17:05:59 -0600
Message-ID: <OF8BC89284.1E31BD25-ON862576B9.007E9507-862576B9.007EE8CA_at_discover.com>
Everybody:
Date: Thu, 28 Jan 2010 17:05:59 -0600
Message-ID: <OF8BC89284.1E31BD25-ON862576B9.007E9507-862576B9.007EE8CA_at_discover.com>
Everybody:
I wanted to thank all who responded for their input. I ended up running alter index rebuild partition nologging parallel. There is no standby / RAC so this solution had no downside. I am going to look into dbms_index_utl.build_indexes() - I have not used it before
Thank you again
Eugene Gurevich
Please consider the environment before printing this email.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 28 2010 - 17:05:59 CST