ORA-12056: invalid REFRESH method Cause: The NEVER REFRESHoption may not be used under the following
conditions:
* The materialized view is updatable
* The materialized view refreshes ON COMMIT
ORA-09870 toORA-12100 8-33
* Automatic refreshoptions are specified Action: For updatable materialized views, reissue the SQL command using
REFRESH FORCE, REFRESH FAST, or REFRESH COMPLETE. For read-only
materialized views, reissue the SQL command using ON DEMAND.
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 2016-8-5 10:03:34
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对