DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Wednesday, January 3, 2018

UDE-31623: operation generated ORACLE error 31623


UDE-31623: operation generated ORACLE error 31623

oracle@SAMPLEEBS:~$  expdp oracle/XXXX schemas=Something  directory=DUMP_DIR dumpfile=something.dmp logfile=something.log

Export: Release - Production on Sat Jan 16 14:43:03 2016

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

Connected to: Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

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 3905
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5203
ORA-06512: at line 1


its because stream pool issue

SQL> show parameter streams_pool_size;

NAME                                 TYPE             VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer      0


keep some value to the streams parameter

SQL> alter system set streams_pool_size=1G scope=both;

System altered.

Retest the issue.

No comments: