DOYENSYS Knowledge Portal




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




Monday, November 3, 2014

EXPDP/IMPDP failing with UDE-31623: operation generated ORACLE error 31623

While exporting we got the following error,


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



The solution for the above error is to increase the stream pool size.
We have changed the stream pool size to 128M from 64M and started the export process which completed successfully.


SYS> show parameter stream

NAME                  TYPE             VALUE
------------------ ------------- ---------
streams_pool_size  big integer      64M


SYS> show parameter stream

NAME                  TYPE             VALUE
------------------ ------------- ---------
streams_pool_size  big integer      128M

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.