Re: gather stats on partitioned tables

From: Karth Panchan <>
Date: Wed, 16 Apr 2014 16:06:07 -0400
Message-Id: <>

I am not how big these two tables?

Did you tried delete stats first and gather stats with granularity ALL.


> On Apr 16, 2014, at 3:14 PM, Sandra Becker <> wrote:
> Oracle EE
> As part of a POC project, I had to import 8 partitioned tables into a new database. Six of them are partitioned on yyyymmdd and I had no problems with them. The last two are range partitioned on an ID column (sequence used to set the ID value). Once I found the correct partitions to match the tables partitioned by date range, I imported them.
> My problem: I cannot get those last two tables to show that they have been analyzed or show a difference in the number of rows for each partition, even though some of the partitions do not have data in the new database. The stats are not locked; checked that first. I've googled and gone to MOS, but nothing I've found so far would tell me why I can't get the stats to change. Suggestions?
> Thank you.
> --
> Sandy

Received on Wed Apr 16 2014 - 22:06:07 CEST

Original text of this message