materialize view error

ALERT LOG 档抛出SNAPSHOT REFRESH ERROR 提示源表无PRIMARY KEY，至使整个REFRESH GROUP 刷新失败。Tue Sep 26 14:23:07 2006
Errors in file /opt/oracle/admin/e3wms/bdump/e3wms_j003_25129.trc:
ORA-12012: error on auto execute of job 3
ORA-12031: cannot use primary key columns from materialized view log on "CELLRPT"."RPT_STAGE_MOVEMENT_DETAIL"
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 803
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 860
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1

用OEM进到此建有MV的DB，进入DATA WAREHOUSE下的REFRESH GROUP 手动刷新，报同样的错误，点开snapshot 查看出错MV ，居然问题出在建有MV LOG 一端的DB ，也同样用OEM登入查看，

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

转载于:http://blog.itpub.net/308563/viewspace-171868/