My Oracle Support Banner

DBMS_STATS.IMPORT_TABLE_STATS Stores Partition Position Instead of Partition Name (Doc ID 2183155.1)

Last updated on MAY 12, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1]
Information in this document applies to any platform.


Symptoms are:
- 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 release.


 Upgrade to 12c.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.