在使用IMPDP导入部分用户的数据时,在导入工作的最后阶段遇到了ORA-39083错误,错误描述如下(job未导入):

一. 问题描述
……

ORA-39083: Object type REFRESH_GROUP failed to create with error:
ORA-23421: job number 141 is not a job in the job queue
Failing sql is:
BEGIN dbms_refresh.make('"VAS"."MVIEW_VAS_SP_DIALTEST"',list=>null,next_date=>null,interval=>null,implicit_destroy=>TRUE,lax=>FALSE,job=>141,rollback_seg=>N
ULL,push_deferred_rpc=>TRUE,refresh_after_errors=>FALSE,purge_option => 1,parallelism => 0,heap_size => 0);
dbms_refresh.add(name=>'"VAS"."MVIEW_VAS_SP_DIALTEST"',list=>'"VAS"."MVIEW_VAS_SP_DIALTEST"',siteid=>0,expo
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 51 error(s) at 05:37:29

二. 问题分校

bing后，发现其他人也遇到了，应该是如下的bug：

ORA-39083 ORA-23421 Impdp Fails Importing REFRESH_GROUP [ID 972344.1]

Cause
The cause of this problem has been identified in Bug 7658844 Import data pump fails importing REFRESH_GROUP with ORA-39083, ORA-23421 if a user other than the refresh group owner does the import.

Solution
To fix the issue:

1. If there is one-off Patch 7658844 available on your current release and for your platform

Or:

2. Upgrade onto release 11.2

Or:

3. Use one of the following workarounds:

- execute impdp by SYSTEM without SCHEMAS parameter, or:
- execute expdp and impdp by the job owner (you may need to pre-create the job owner on the target database).

三. 问题解决

我这里采用的是不加schema，用system单独导入job：
impdp system/hc directory=dumpdir include=job dumpfile=hc_expdp_%U.dmp remap_tablespace=VAS_TEMP:TEMP logfile=hc_impdp0615_job.log parallel=10

问题解决，job进去了。