Re: Rebuild table
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 21 Jun 2011 22:46:37 +0200
On 21/06/2011 22:34, Sheehan, Jeremy wrote:
Lots of good information pouring in. just make sure to check for
invalid objects post move/rebuild.
Do the table move and/or the index rebuild invalidate objects?
If you do CTAS, make sure you get the permissions correct on the new
table, too.
Yes,
don't forget to assign the necessary grants,
check for default values[1] and don't forget to
check the degree of parallelism and the logging/nologging
settings before and after the operations[2].
Don't forget to gather statistics on the newly created/re-created objects.
Am I missing something?
Regards
Dimitre
[1] Thanks to Kamran Agayev for that,
see
kamranagayev.wordpress.com/2011/01/13/beware-of-default-values-when-using-ctas/
[2] Thanks to Tanel Poder, see
blog.tanelpoder.com/2007/06/23/a-gotcha-with-parallel-index-builds-parallel-degree-and-query-plans/
Other related posts:
