ORA-25205: the QUEUE SYS.KUPC$S_1_20180123193821 does not exist

[oracle@hbjfdba:/oratmp]#expdp \'XXX as sysdba\' DIRECTORY=TMP_DUMP_DIR DUMPFILE=NEW_LOCAL_HB_DMN_%U.dmp SCHEMAS=NEW_LOCAL_HB_DMN exclude=statistics logfile=NEW_LOCAL_HB_DMN_exp.log version=10.2.0.2 ;

Export: Release 10.2.0.4.0 - 64bit Production on Tuesday, 23 January, 2018 19:38:20

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options

Starting "SYS"."SYS_EXPORT_SCHEMA_03": 'sys/******** AS SYSDBA' DIRECTORY=TMP_DUMP_DIR DUMPFILE=NEW_LOCAL_HB_DMN_%U.dmp SCHEMAS=NEW_LOCAL_HB_DMN exclude=statistics logfile=NEW_LOCAL_HB_DMN_exp.log version=10.2.0.2 

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

UDE-00008: operation generated ORACLE error 39078

ORA-39078: unable to dequeue message for agent KUPC$A_1_20180123193822 from queue "KUPC$S_1_20180123193821"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE_INT", line 565

ORA-25205: the QUEUE SYS.KUPC$S_1_20180123193821 does not exist

ORA-06512: at "SYS.DBMS_DATAPUMP", line 2772

ORA-06512: at "SYS.DBMS_DATAPUMP", line 3886

ORA-06512: at line 1

-- 可能存在的原因， streams_pool 太小，稍稍調大一點

SQL> show parameter stream

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

streams_pool_size big integer 400M

SQL> alter system set streams_pool_size=500m scope=both sid='hbdw1';

System altered.

SQL> alter system set streams_pool_size=500m scope=both sid='hbdw2';

調整後，沒有報錯。

本文轉自 張沖andy 部落格園部落格，如需轉載請自行聯系 原作者原文連結：http://www.cnblogs.com/andy6/p/8341421.html