DataPump Export Fails With Errors ORA-39065 ORA-39079 ORA-24033
(Doc ID 1314791.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
When exporting a schema with a large number of objects or a full database containing such a schema you receive errors like:
ORA-39079: unable to enqueue message RP,KUPC$C_1_20110415093907,MCP,KUPC$A_1_20110415093909,12,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 924
ORA-24033: no recipients for message
This situation can be encountered for Peoplesoft databases where schema SYSADM has a large number of objects.
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