ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 10g impdp use schema mode

Oracle 10g impdp use schema mode

原创 Linux操作系统 作者:flyerchen2000 时间:2011-09-05 10:51:25 0 删除 编辑
Use impdp schema= , show below error:

ORA-23421: job number 43 is not a job in the job queue
Failing sql is:
 BEGIN dbms_refresh.make('"AMTSMGR"."SEAINV_SEATRK_CATEGORIES_MV"',list=>null,next_date=>null,interval=>null,implicit_destroy=>TRUE,lax=>FALSE,job=>43
,rollback_seg=>NULL,push_deferred_rpc=>TRUE,refresh_after_errors=>FALSE,purge_option => 1,parallelism => 0,heap_size => 0);
dbms_refresh.add(name=>'"AMTSMGR"."SEAINV_SEATRK_CATEGORIES_MV"',list=>'"AMTSMGR"."SEAINV_SEATRK_CA
ORA-39083: Object type REFRESH_GROUP failed to create with error:

Action: populate rgroup$ in destination database.

Cause: rgroup$ belong to sys , normal schema , imp not include this table.

Re-think: Full database imp will avoid this issue.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/3637/viewspace-706651/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-08-25

  • 博文量
    44
  • 访问量
    75683