DBMS_STATS.IMPORT_TABLE_STATS Stores Partition Position Instead of Partition Name
Last updated on AUGUST 25, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 12.1]
Information in this document applies to any platform.
- export partition statistics using dbms_stats.export_table_stats for a partition
- drop table and recreate the table with new partitions; afterwords try to import statistics on that specific partition using dbms_stats.import_table_stats
- if the partition in the new table has a new position, no statistics are imported
- statistics table keeps the position of the partition, not the partition name
This behaviour is not present in 126.96.36.199 release.
Upgrade to 12c.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms