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

Issue:

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 12.1.0.2.0 - 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 12.1.0.2.0 - 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

Cause:

its because stream pool issue

SQL> show parameter streams_pool_size;

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


Solution:

keep some value to the streams parameter

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

System altered.

Retest the issue.

No comments: