Re: Rebuild table
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Tue, 21 Jun 2011 22:46:37 +0200
Message-ID: <4E01032D.1070809_at_gmail.com>
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.
>
Date: Tue, 21 Jun 2011 22:46:37 +0200
Message-ID: <4E01032D.1070809_at_gmail.com>
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/
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 21 2011 - 15:46:37 CDT