Re: Rebuild table

From: Radoulov, Dimitre <>
Date: Tue, 21 Jun 2011 22:46:37 +0200
Message-ID: <>

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.

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?


[1] Thanks to Kamran Agayev for that,

[2] Thanks to Tanel Poder, see

Received on Tue Jun 21 2011 - 15:46:37 CDT

Original text of this message