Database Utilities (MOSC)

MOSC Banner

Help!! -- Full import (via imp) from 10.2.0.4 into 11.2.0.3.1 failed to import DBMS jobs! IMP-00017:

edited Jan 25, 2012 4:06AM in Database Utilities (MOSC) 4 commentsAnswered
Hello! 

Can anyone help me regarding why dbms jobs can not be full imported???  Many thanks!  Joy

I used traditional exp to FULL export 10.2.0.4 database.

I used tradtional imp to FULL import  it into 11.2.0.3.1 database.

Same platform, os version.

But my dbms jobs failed to be imported with error below. (NOTE: I have never had issues like this when exp/imp 10.2.0.4 to 10.2.0.4)

. importing CADASTRAL's objects into CADASTRAL
IMP-00017: following statement failed with ORACLE error 23300:
 "BEGIN   SYS.DBMS_IJOB.SUBMIT(JOB=>2,LUSER=>'CADASTRAL',PUSER=>'CADASTRAL',C"
 "USER=>'CADASTRAL',NEXT_DATE=>TO_DATE('2012-01-22:14:30:00','YYYY-MM-DD:HH24"
 ":MI:SS'),INTERVAL=>'TRUNC(NEXT_DAY(SYSDATE,''SUNDAY''))+14.5/24',BROKEN=>FA"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center