ERROR at line 1: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
来源:互联网 发布:unity3d ugui摇杆 编辑:程序博客网 时间:2024/06/04 19:20
SQL> select * from ii;
N V
---------- --------
1 a
2 b
3 c
SQL> alter table ii add constraint ii_p primary key(n);
Table altered.
SQL> create materialized view v_ii refresh force on commit as select * from ii;
Materialized view created.
SQL>
N V
---------- --------
1 a
2 b
3 c
SQL> alter table ii add constraint ii_p primary key(n);
Table altered.
SQL> create materialized view v_ii refresh force on commit as select * from ii;
Materialized view created.
SQL>
- ERROR at line 1: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
- ORA-12052: cannot fast refresh materialized view DCS_BIZ.MV_TMP_16
- This page contains the following errors: error on line 1 at column 1: Extra content at the end of t
- 服务器返回出现:error on line 19 at column 1: Extra content at the end of the document
- MATERIALIZED VIEW 的Refresh
- OCI Error ORA-12096: error in materialized view log on "JTINFO"."TBL_USERID"
- ORA-12032: cannot use rowid column from materialized view log on "DCS_BIZ"."TMP_12"
- This page contains the following errors: error on line 1 at column 1: Document is empty Below is a
- ORA-10652: Object has on-commit materialized views
- org.dom4j.DocumentException: Error on line 1 of document : The markup in the document following the
- warning: failed to set breakpoint site at 0x1005ed32c for breakpoint 28.1: error sending the breakpo
- Multiple annotations found at this line: - cvc-elt.1: Cannot find the declaration of element 'ehcac
- xml无法显示(Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again la
- ERROR 'duplicate declaration of type/attribute' at token ';' on line 14430
- Finding and fixing the stack overflow at line 0 error
- APP-WSH-231210 An unexpected Error Occurred for Line .. The Error is ORA-04062 signature of package
- MyEclipse Error: The Table cannot be found on the database
- MyEclipse Error: The Table cannot be found on the database
- Flex 性能优化
- GPRS CMS&CME error
- UIView与CAlayer
- js 之 sleep小实现
- oracle数据库无响应
- ERROR at line 1: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
- 游戏类型
- Outlook 自动发送 密抄 自己 可多人密抄
- VB工程--百例92---拍照窗体
- 从一道面试题谈linux下fork的运行机制
- regsvr32不是内部或外部命令,也不是可运行的程序
- 实战:脚本监控sqlserver 2008 R2 replication性能
- sap LICENSE KEY和 ACCESS KEY 破解 .
- android activity 背景 透明 设置方法