gather stats on partitioned tables
- From: Sandra Becker <sbecker6925@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Apr 2014 13:14:38 -0600
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
Other related posts:
