oracle 21c expdp报错误UDE-31623

 

环境:

OS:Centos 7

DB:21C

 

导出报错

expdp c##goldengate/goldengate@tnspdb1 tables=hxl.tb_test dumpfile=tb_test.dmp FLASHBACK_SCN=4990304 parallel=5 directory=DATA_PUMP_DIR cluster=n reuse_dumpfiles=true version=11.2.0.4
[oracle@21c_single dpdump]$ expdp c##goldengate/goldengate@tnspdb1 tables=hxl.tb_test dumpfile=tb_test.dmp FLASHBACK_SCN=4990304 parallel=5 directory=DATA_PUMP_DIR cluster=n reuse_dumpfiles=true

Export: Release 21.0.0.0.0 - Production on Wed Oct 12 10:36:08 2022
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747
ORA-06512: at "SYS.KUPV$FT_INT", line 2330
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2245
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4496
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127
ORA-06512: at line 1

 

解决办法：
sqlplus / as sysdba
show parameter streams_pool_size
select * from v$sgainfo; #其实为0
alter system set streams_pool_size=64M scope=spfile;

重启动数据库
shutdown immediate
startup
alter pluggable database all open;