Re: Rebuild table

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Tue, 21 Jun 2011 22:58:44 +0200
Message-ID: <4E010604.3090308_at_gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 21 2011 - 15:58:44 CDT