I face this issue while try to take export by using datapump

My system is:

AIX:6.1
Db verison:10.2.0.5
Method: expdp

Error message is:

RA-31626: job does not exist
ORA-31637: cannot create job xxx for user TEST
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPV$FT_INT”, line 600
ORA-39080: failed to create queues “KUPC$C_1_20110404213614” and “KUPC$S_1_20110404213614” for Data Pump job
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPC$QUE_INT”, line 1606
ORA-04031: unable to allocate 56 bytes of shared memory (“streams pool”,”unknown object”,”streams pool”,”fixed allocation callback”)

Workaround:

alter system flush shared_pool

alter system flush buffer_cache

select * from v$parameter where name like ‘%sga%’

alter system set sga_target=3000M  #Here we are increasing sga_target size

 

Reklam