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 laterInformation 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 |