环境:
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;
标签：DBMS,expdp,SYS,21c,UDE,line,06512,31623,ORA From： https://www.cnblogs.com/hxlasky/p/16783756.html