Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message.

ORA-39083: Object type JOB failed to create with error: ORA-00001:
unique constraint (SYS.I_JOB_JOB) violated Failing sql is:  BEGIN
DBMS_JOB.ISUBMIT( JOB=> 4002, NEXT_DATE=> TO_DATE('2012-07-13
14:29:31', 'YYYY-MM-DD:HH24:MI:SS'), INTERVAL=> 'sysdate + 10/1440',
WHAT=>
 'wwv_flow_mail.push_queue(wwv_flow_platform.get_preference(''SMTP_HOST_ADDRESS''),wwv_flow_platform.get_preference(''SMTP_HOST_PORT''));',
 NO_PARSE=> TRUE); END;

 Processing object type
 DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA Job
 "TMSMV"."SYS_IMPORT_FULL_01" completed with 1255 error(s) at 12:24:24

I used following commands:

expdp tmsmv/password full=y dumpfile=tmsdump20120113-558.dmp logfile=tmslog20120713-558.log

impdp tmsmv/password full=y dumpfile=tmsdump20120113-558.dmp logfile=tmslog20120713-558.log

How can I resolve this issue?

share|improve this question

1 Answer 1

Looks like there is already a job on the imported database with that job number. Just recreate the job on the import database.

The job looks to be a queue so you could, depending on your business procedures, probably run the new job to test that everything is working.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.