RE: segment fragmentation
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 08 Sep 2004 17:49:30 -0600
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@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
