Oracle 10g impdp use schema mode
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.
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博客 ” ，链接：https://blog.itpub.net/3637/viewspace-706651/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
挠痒要挠到痒处——了解你的孩子
下一篇：
宝贝不哭，妈妈打它--转贴
请登录后发表评论
登录
全部评论
