Apply了补丁PSU 10.2.0.5.180717后，DataPump的问题就格外多。如下所示：
expdp system/xxx DIRECTORY=DUMPDIR DUMPFILE=xxxx.dmp TABLES=xxxx.xxxx LOGFILE=expdp.log
Export: Release 10.2.0.5.0 - 64bit Production on Monday, 19 August, 2019 9:52:07
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 672
ORA-39080: failed to create queues "" and "" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1606
ORA-01403: no data found
遇到这个错误，最开始我以为是我之前遇到的是同一个问题“Expdp 导数错误 ORA-00832”，检查发现__streams_pool_size大小不为0
col name for a36;
col value for a10;
col idfefault for a10;
col ismod for a10;
col isadj for a10;
SELECT X.ksppinm name ,
Y.ksppstvl value ,
Y.ksppstdf idfefault ,
DECODE(bitand(Y.ksppstvf,7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE') ismod,
DECODE(bitand(Y.ksppstvf,2), 2, 'TRUE', 'FALSE') isadj
FROM sys.x$ksppi X,
sys.x$ksppcv Y
WHERE X.inst_id = userenv('Instance') AND
Y.inst_id = userenv('Instance') AND
X.indx = Y.indx AND
X.ksppinm LIKE '%_streams%'
ORDER BY translate(X.ksppinm, '_', '');
NAME VALUE IDFEFAULT ISMOD ISADJ
------------------------------------ ---------- ---------- ---------- ----------
__streams_pool_size 33554432 FALSE FALSE FALSE
_memory_broker_shrink_streams_pool 900 TRUE FALSE FALSE
_disable_streams_pool_auto_tuning FALSE TRUE FALSE FALSE
_streams_pool_max_size 0 TRUE FALSE FALSE
然后开启跟踪'1403 trace name errorstack level 3'，执行导出命名后，然后关闭跟踪'1403 trace name errorstack off'
alter system set events '1403 trace name errorstack level 3';
run the expdp command
alter system set events '1403 trace name errorstack off';
查看trace文件，如下截图所示，提示“ksedmp:internal or fatal error" ,搜索了一下metalink，发现还真有一模一样的错误
73542-20190819155432645-1262367573.png
在验证表结构时，发现表不存在，所以必须reload the DataPump utility， reload the DataPump utility候就能正常的导入导出了。
SQL> analyze table kupcdatapump_quetab validate structure
*
ERROR at line 1:
ORA-00942: table or view does not exist
具体的官方文档如下所示：
DataPump Import Or Export (IMPDP/EXPDP) Fails With Errors ORA-31626 ORA-31637 (文档 ID 345198.1)
https://www.cnblogs.com/kerrycode/p/11377646.html
