ORA-31684 Object Type Already Exists ORA-39112 when Running Data Pump Import into an Empty Database

APPLIES TO:
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.1.0.0.0 [Release 12.2 to 19]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

SYMPTOMS
The issue is seen when running Data Pump import of new data into version 12.2 database.
The database has been created but no previous schema data has been loaded.
New schema data is being imported but import generates ORA-31684 object already exists for many objects:

impdp system/******** DIRECTORY=DATA_PUMP_DIR PARALLEL=2 SCHEMAS=user1 REMAP_SCHEMA=user1:test1 REMAP_TABLESPACE=user1ts:test1ts dumpfile=.dmp logfile=.log

…
ORA-31684: Object type PROCEDURE:“TEST1”.“TEST1_QUOTE” already exists
ORA-31684: Object type PROCEDURE:“TEST1”.“TEST1_STAGE” already exists
ORA-31684: Object type PROCEDURE:“TEST1”.“TEST1__TASK” already exists
ORA-31684: Object type PROCEDURE:“TEST1”.“TEST1__TRANSLATE” already exists

• OR -

ORA-31684: Object type already exists
ORA-39112: Dependent object type SYNONYM: skipped, base object type creation failed

CHANGES

CAUSE
New database or new schema created in version 12.2. The ORA-31684 is caused by the use of the PARALLEL parameter. When using PARALLEL greater than 1, the action for that object is executed more than once and the additional executions generates the error ORA-31684.

This 12.2 Data Pump issue is caused by Bug 27577866 IMPDP ON 12.2 IMPORTING SAME CONSTRAINTS TWICE WITH PARALLEL>1.

There is also Bug 28451919 - ORA-31684 ORA-ORA-39112 ORA-39111 EXECUTING IMPORT IN PARALLEL, which fixes additional instances of the ORA-31684 error not covered by the fix for Bug 27577866.

Both Bug 27577866 and Bug 28451919 are regressed and their correction is supplied via the superseding Bug 28539085 - DUPLICATE OBJECT IN IMPORT FULL WITH PARALLEL=4 ORA-31684 ORA-39112 OTHERS.

With the fix of Bug 28539085 in place, Data Pump allows the following objects to be imported in parallel: SEQUENCE, VIEW, TRIGGER, OBJECT_GRANT, CONSTRAINT and REF_CONSTRAINT.

NOTE: Bug 28539085 is superseded by Bug 29613245 - ORA-31684 ORA-39112 WITH FIX 28539085 AND VERSION=11.2.
SOLUTION

1. Upgrade to 21.1 when available, where fix of Bug 29613245 is included.

• OR -

2. Apply Generic Patch 29613245 if available for your version and platform or any merge patch that contains the fix of Bug 29613245.

To check for conflicting patches, please use the MOS Patch Planner Tool.

Reference:
How to Use MOS Patch Planner to Check and Request the Conflict Patches? (Note 1317012.1)

If no patch exists for your platform and version, please contact Oracle support to request a fix

• OR -

3. Work around offered: Use parallel=1 in the import command