msabuu
asked on
EXPORT
I have investigated the cause of L1009 datapump export failure. The
following errors reported in export log file:
ORA-31626: job does not exist
ORA-31637: cannot create job exp_OPS$IHESS\SRVORACLEBAT CH for user
OPS$IHESS\SRVORACLEBATCH
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_20080611182005" and
"KUPC$S_1_20080611182005" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
ORA-04031: unable to allocate 56 bytes of shared memory ("streams
pool","unknown object","streams pool","fixed allocation callback")
--
expdp / directory=data_pump_dir dumpfile=schema_%SCH%.nigh tly_dmp
logfile=schema_%SCH%.log job_name=exp_%SCH1% schemas=%SCH1%
estimate=statistics flashback_time=\"to_timest amp('%ltim e%','dd-mo n-yy
hh24:mi:ss')\"
Here SCH will be replaced with Schema name(OPS$IHESS\SRVORACLEBA TCH,
SYSTEM, VRS_SHR_OWNER). The export of these schemas got failed due to
unable to find the jobs which mentioned at job_name parameter. These
jobs
might not be created because insufficient or unable to allocate space in
shared memory at that time.
Please advice me
following errors reported in export log file:
ORA-31626: job does not exist
ORA-31637: cannot create job exp_OPS$IHESS\SRVORACLEBAT
OPS$IHESS\SRVORACLEBATCH
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_20080611182005" and
"KUPC$S_1_20080611182005" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1580
ORA-04031: unable to allocate 56 bytes of shared memory ("streams
pool","unknown object","streams pool","fixed allocation callback")
--
expdp / directory=data_pump_dir dumpfile=schema_%SCH%.nigh
logfile=schema_%SCH%.log job_name=exp_%SCH1% schemas=%SCH1%
estimate=statistics flashback_time=\"to_timest
hh24:mi:ss')\"
Here SCH will be replaced with Schema name(OPS$IHESS\SRVORACLEBA
SYSTEM, VRS_SHR_OWNER). The export of these schemas got failed due to
unable to find the jobs which mentioned at job_name parameter. These
jobs
might not be created because insufficient or unable to allocate space in
shared memory at that time.
Please advice me
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oracle 10g R2
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Data Pump doesn't work stable before Oracle 10g R2 (10.2.0.1)