-
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!
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|