My Oracle Support Banner

Insert Statement Returns Error ORA-14400 When Parallel Dml Is Enabled (Doc ID 1545131.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
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


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