Insert Statement Returns Error ORA-14400 When Parallel Dml Is Enabled
(Doc ID 1545131.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.2.0.1 [Release 11.2 to 12.2]Information in this document applies to any platform.
Symptoms
On production database 11.2.0.3 version:
When attempting to run the Insert in parallel, it fails with the following error.
ALTER SESSION ENABLE PARALLEL DML;
ERROR
-----------------------
INSERT
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P003
ORA-14400: inserted partition key does not map to any partition
The issue is not seen when the same statement is executed using
ALTER SESSION DISABLE PARALLEL DML;
Problematic Plan:
------------------
---------------------------------------------------------------------------
| Id | Operation | Name | TQ |IN-OUT| PQ Distrib
---------------------------------------------------------------------------
| 0 | INSERT STATEMENT | | | |
| 1 | PX COORDINATOR | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10001 |Q1,01 | P->S | QC (RAND)
| 3 | LOAD AS SELECT | T1 |Q1,01 | PCWP |
| 4 | VIEW | |Q1,01 | PCWP |
| 5 | SORT ORDER BY | |Q1,01 | PCWP |
| 6 | PX RECEIVE | |Q1,01 | PCWP |
| 7 | PX SEND PARTITION (KEY)| :TQ10000 |Q1,00 | P->P | PART (KEY)
| 8 | PX BLOCK ITERATOR | |Q1,00 | PCWC |
| 9 | TABLE ACCESS FULL | T2 |Q1,00 | PCWP |
---------------------------------------------------------------------------
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |