My Oracle Support Banner

Primary Note for Most Frequent Errors During Partition Operations (Doc ID 1395403.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

How to use this document:
This article has been created to provide a path to existing My Oracle Support articles that have been written to cover the many possible 'ORA-' errors in partitioning. The Error Explanation is taken from Error Messages Reference version 11.2. 
Please follow the links above or use the error message you would like a possible solution to as the search criteria (Ctrl-f) within this document.

The search will take you to the section that explains the error, and provides links to existing documents (where they exist) in My Oracle Support. These documents have been written from previous occurrence of the error and show the Cause and Solution in each case.

Scope

This is article is intended for DBAs, Users and Support Engineers who have received an ORA- type error during partitioning operations.

Details

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
Purpose
Scope
Details
 1. ORA-14400: inserted partition key does not map to any partition
 2. ORA-14401: inserted partition key is outside specified partition
 3. ORA-14074: partition bound must collate higher than that of the last partition
 4. ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
 5. ORA-14006: invalid partition name
 6. ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
 7. ORA-14523: Cannot co-locate [sub]partition of string string with table
 8. ORA-01502: index 'string.string' or partition of such index is in unusable state
 9. ORA-14257: cannot move partition other than a Range, List, System, or Hash partition
 10. ORA-14758: Last partition in the range section cannot be dropped
 11. ORA-01882: timezone region not found
 12. ORA-14652: reference partitioning foreign key is not supported
 13. ORA-14083:cannot drop the only partition of a partitioned table
 14. ORA-20000: index "xxx"."xxx" or partition of such index is in unusable state (e.g. GATHER_STATS_JOB tries to collect stats on affected index).
 15. ORA-14037: partition bound of partition <partition name> is too high
 
 Still have questions? Visit Database Data Warehousing Community
References

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