RE: segment fragmentation

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 08 Sep 2004 17:49:30 -0600
Message-Id: <6.1.0.6.2.20040908174757.02ebc650@pop.centrexcc.com>

Excellent point about the statistics. I recently discovered that alter table move in Oracle 9 (9.2.0.5) seems to delete the statistics. I do not recall that from Oracle 8.

At 05:26 PM 9/8/2004, Reardon, Bruce (CALBBAY) wrote:
>Also, something others may know but I ran into recently.
>When you move a table, posts normally point out that indexes will need =
>to be rebuilt (as the post below does).
>You also need to recreate statistics (by your method of preference - =
>dbms_stats gathering, analyze or dbms_stats setting) on the table and =
>indexes.
>HTH,
>Bruce Reardon

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Received on Wed Sep 08 2004 - 18:46:13 CDT