有数据冲突,我后面想把备用的数据truncate掉,提示 ORA-02266: 表中的唯一/主键被启用的外键引用 用语句ALTER TABLE bd_cubasdoc disable primary key cascade; 可以执行truncate,但现在的问题是建好物化视图后刷新不了,提示 exec DBMS_MVIEW.REFRESH(LIST=>'bd_cubasdoc',METHOD=>'COMPLETE');ORA-12008: error in materialized view refresh path ORA-02291: integrity constraint (NC57.F_PUB_BD_3) violated - parent key not found ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426 ORA-06512: at line 2
Yakecanz 有具体的步骤吗,job不是很懂,谢谢
用语句ALTER TABLE bd_cubasdoc disable primary key cascade;
可以执行truncate,但现在的问题是建好物化视图后刷新不了,提示
exec DBMS_MVIEW.REFRESH(LIST=>'bd_cubasdoc',METHOD=>'COMPLETE');ORA-12008: error in materialized view refresh path
ORA-02291: integrity constraint (NC57.F_PUB_BD_3) violated - parent key not found
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426
ORA-06512: at line 2
这样的话,就建个job,通过dblink传就是了.