DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: import error with "unused job number"

  1. #1
    Join Date
    Apr 2001
    Posts
    257
    I've tried to import from a dump file but toward the end of the import, I received this error:
    --------
    IMP-00017: following statement failed with ORACLE error 23422:
    "BEGIN dbms_job.isubmit(job=>172391,what=>'search_indexing.sync_index;',ne"
    "xt_date=>to_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),interval=>'"
    "null',no_parse=>true); END;"
    IMP-00003: ORACLE error 23422 encountered
    ORA-23422: Oracle Server could not generate an unused job number
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
    ORA-06512: at "SYS.DBMS_JOB", line 140
    ORA-06512: at "SYS.DBMS_JOB", line 96
    ORA-06512: at line 1
    -------

    Please help!
    Thanks!


  2. #2
    Join Date
    May 2002
    Posts
    2,645
    In general, this is what the error is about:

    Error: ORA-23422
    Text: Oracle Server could not generate an unused job number
    ---------------------------------------------------------------------------
    Cause: Oracle Server could not generate a job number that was not used to
    identify another job.
    Action: Retry the operation.


    The IMP-0017 isn't fatal to the import. You may have to re-submit the job in the new database.

  3. #3
    Join Date
    Apr 2001
    Posts
    257
    Thanks for the info. I was wondering why Oracle suggested retry the operation and why it could have helped if I retried it.

    After I dropped the schema and reimported, surprisingly, it did not complain anymore.

    is this a bug or something??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width