Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to clean dba_datapump_jobs

755353May 11 2010 — edited Nov 20 2012

Hi
Im recieving below errors in the exp log files

ORA-39127: unexpected error from call to export_string :=SYS.DBMS_AQ_EXP_QUEUE_TABLES.instance_info_exp('T_MIE_ERROR_CHANNEL_TAB','DEV_AUD_0809',1,1,'11.01.00.00.00',newblock)
ORA-01403: no data found
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_AQ_SYS_EXP_ACTIONS", line 90
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUE_TABLES", line 20
ORA-06512: at line 1

have searched the metalink and found below doc

ORA-39127 when executing concurrent expdp sessions. [ID 742789.1]

work around
Avoid running concurrent expdp jobs.

fix
Issue is caused by Bug:7112024 which is fixed in 11.1.0.7.0

I dont remember running multiple concurrent export! but I can see some sessions hanging in dba_dump_files

SQL> select JOB_NAME,STATE from dba_datapump_jobs;

JOB_NAME STATE
------------------------------ ------------------------------
EXPDEV NOT RUNNING
SYS_EXPORT_SCHEMA_01 NOT RUNNING
IMPORT_USER000002 NOT RUNNING

once i tried running the exp as EXPDEV and it came back saying the table already exist ...

how can i clear them ? before -re running the export?

the export has completed successfully do i really need to re-run the export?