Re: losing global statistics after exchange partition (8.1.7.4)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 1 Sep 2004 20:38:58 +0000 (UTC)
Message-ID: <ch5c12$8e9$1@sparta.btinternet.com>

Are you adding an empty partition BEFORE exporting the stats or after exporting the stats. There are some really odd features to global stats in 8.1.7.4, one being that the stats disappear on just about any partition maintenance.

If you are exporting before adding the empty partition, check the contents of the export table to see if it hold stats for all the partitions and the table - you may have to run two exports to get all the stats, and two imports to reload them.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated July 27th




"prom" <promanek_at_hektor.umcs.lublin.pl> wrote in message
news:cgv9r5$4er$1_at_opal.futuro.pl...


> Hello all!

>   I'm having problem with rollup. I'm using following scheme for every

> summary table T [ T is partitioned table ]:

>      1)export stats of T

>      2)fill temporary table TMP (not partitioned)

>      3)exchange partition (T <-> TMP)

>      4)import stats.

> But after all, global statistics of every table T are lost (database

> 8.1.7.4). The same schema works fine on 9i. I cannot rebuild statistcs

> frequently, because it takes too much time. Procedure

> dbms_stats.import_table_stats has additional parameter - no_invalidate

> on 9i. Is there any way to do exchange partition on 8i without marking

> global stats as invalidated ??

>

> Regards

> Pawel

Received on Wed Sep 01 2004 - 15:38:58 CDT