My Oracle Support Banner

ORA-39006 ORA-39065 ORA-01422 During Data Pump Export (Doc ID 2590201.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

PDB DataPump Export fails with error ORA-01422:

expdp <USERNAME>/<PASSWORD>@<PDB_NAME1> DIRECTORY=DATAPUMP_DIR1 ...

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.KUPF$FILE", line 4535

ORA-39097: Data Pump job encountered unexpected error -1422

Run following query to check where the directory is created.  This example shows container id 1 which is root:

SQL> select ORIGIN_CON_ID, DIRECTORY_NAME, DIRECTORY_PATH from dba_directories;

1 <------------
DATAPUMP_DIR1
<DP_DIRECTORY_PATH>


Issue following command to identify container id for the PDB that you are trying to export:

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 <PDB_NAME1> READ WRITE NO
4 <PDB_NAME2> READ WRITE NO  <-----

Enabling the errorstack for the error ORA-01422:

alter system set events '1422 trace name errorstack level 3';

and running export again, the following details are found in the trace file:

----- Current SQL Statement for this session (sql_id=10c4pnc76q85z) -----

SELECT DECODE(upper(read), 'TRUE', 1, 0),
DECODE(upper(write), 'TRUE', 1, 0)
FROM SYS.LOADER_DIR_OBJS
WHERE name = :l_directory

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x3dee74990 4499 package body SYS.KUPF$FILE.CHECK_ACCESS
0x3df425e38 4133 package body SYS.KUPM$MCP.ADD_FILE
0x3df425e38 1756 package body SYS.KUPM$MCP.DISPATCH
0x3df425e38 1435 package body SYS.KUPM$MCP.MAINLOOP
0x3df425e38 1105 package body SYS.KUPM$MCP.MAIN
0x2f95041d8 2 anonymous block

----- Call Stack Trace -----

... kgeade kgeselv ksesecl0 rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool...

 

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


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