Export_db

[Arsalan]

Salam Sir

every day i take expdp fine but today i face below error

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining 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 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

Google says change value 0

i change to

alter system set streams_pool_size=1024M scope=spfile sid='*';

but still i can not expd

pleas guide me

[ErmanArslansOracleBlog]

This is already adressed in Oracle support.
Having a insufficient size in streams_pool_size is just one the reasons.

there are several reasons for this error..
invalid registry components,  invalid Data Pump queue objects, having _FIX_CONTROL set for Bug 6167716 are some of them. There are more...

Follow the MOS note-> How to resolve the Data Pump error ORA-31623 UDE-31623 (a job is not attached to this session via the specified handle) ? (Doc ID 1907256.1)

[Arsalan]

Thanks sir

i crease the size of stream pool