Re: Rebuild table

On 21/06/2011 22:46, Radoulov, Dimitre wrote:

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?


Yes, I am.

Compression:


SQL> select TABLE_NAME,COMPRESSION from user_tables;

TABLE_NAME                     COMPRESS
------------------------------ --------
T                              ENABLED

SQL> create table tt as select * from t;

Table created.

SQL>  select TABLE_NAME,COMPRESSION from user_tables;

TABLE_NAME                     COMPRESS
------------------------------ --------
T                              ENABLED
TT                             DISABLED
And, as already stated, if you choose to do a CTAS + table (and index) rename, 
check for invalid objects.


Dimitre

Other related posts: