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

While exporting we got the following error,

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

SOLUTION:

 
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

  • January 4, 2018 | 22 views
  • Comments