Thanks, everyone. Scott nailed. The database is set to "not" publish stats. Once I published them, everything was good. Sandy On Wed, Apr 16, 2014 at 1:52 PM, Mark W. Farnham <mwf@xxxxxxxx> wrote: > I'd look into Doug Burns' stuff on this topic. Either via > www.oaktable.net or directly at http://oracledoug.com/serendipity/ > > > > mwf > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Sandra Becker > *Sent:* Wednesday, April 16, 2014 3:15 PM > *To:* oracle-l > *Subject:* gather stats on partitioned tables > > > > Oracle EE 11.2.0.2 > > > > 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 > GHX > -- Sandy Transzap, Inc.