Tuesday, 18 April 2017

UDE-00008: operation generated ORACLE error 39078 | Oracle EXPDP\IMPDP

 UDE-00008: operation generated ORACLE error 39078 | Oracle EXPDP\IMPDP

One more error that I faced while Exporting Database out of Oracle Database using Export Datapump Utility.

UDE-00008: operation generated ORACLE error 39078
ORA-39078: unable to dequeue message for agent KUPC$A_1_20160907164749 from queue "KUPC$S_1_20160907164748"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 559
ORA-25205: the QUEUE SYS.KUPC$S_1_20160907164748 does not exist
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2315
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3185
ORA-06512: at line 1


There's one thing good or I would say best about Oracle Databases that you'll get everything you need if know how to Google it. OR 24/7 Oracle Support is always there.

No I am not promoting Oracle here, I just told you what I like about being with Oracle.

Ok, let's just come to the Solution. In my case, the problem was because of poor allocation of STREAMS_POOL_SIZE parameter. To make my system resourceful, I used to play with memory parameters so that I can control the usage of memory in my system.

All I had to do was increase STREAMS_POOL_SIZE, provide required memory to it and the issue was resolved.

No comments:

Post a comment