ORA-01733: virtual column not allowed here
来源:互联网 发布:淘宝我的卡券包在哪里 编辑:程序博客网 时间:2024/06/04 18:28
基表: hr.tt scott.tt
视图1: 基于 hr.tt union all scott.tt ---》 scott.ttt
视图2: 基于 视图1-》scott.ttt 创建 system.tt
问题再现:
SQL> create table hr.tt (a number);
Table created.
SQL> create table lixora.tt (a number);
Table created.
SQL> create view scott.tt as select * from hr.tt union all select * from lixora.tt;
View created.
SQL> create view system.tt as select * from scott.tt;
View created.
SQL> select * from system.tt
A
----------
1
更新视图2:
SQL> update system.tt set a=2;
update system.tt set a=2
*
ERROR at line 1:
ORA-01733: virtual column not allowed here
更新视图1:
SQL> update scott.tt set A=2;
update scott.tt set A=2
*
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
SQL> !oerr ora 1732
ORA-01733: virtual column not allowed here
Cause: An attempt was made to use an INSERT, UPDATE, or DELETE statement on an expression in a view.
Action: INSERT, UPDATE, or DELETE data in the base tables, instead of the view.
视图1: 基于 hr.tt union all scott.tt ---》 scott.ttt
视图2: 基于 视图1-》scott.ttt 创建 system.tt
问题再现:
SQL> create table hr.tt (a number);
Table created.
SQL> create table lixora.tt (a number);
Table created.
SQL> create view scott.tt as select * from hr.tt union all select * from lixora.tt;
View created.
SQL> create view system.tt as select * from scott.tt;
View created.
SQL> select * from system.tt
A
----------
1
更新视图2:
SQL> update system.tt set a=2;
update system.tt set a=2
*
ERROR at line 1:
ORA-01733: virtual column not allowed here
更新视图1:
SQL> update scott.tt set A=2;
update scott.tt set A=2
*
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
SQL> !oerr ora 1732
ORA-01733: virtual column not allowed here
Cause: An attempt was made to use an INSERT, UPDATE, or DELETE statement on an expression in a view.
Action: INSERT, UPDATE, or DELETE data in the base tables, instead of the view.
总结:
无法对包含表达式的view 进行dml 操作
1 0
- ORA-01733: virtual column not allowed here
- 用merge into 的时候提示 ORA-01733: virtual column not allowed here
- Oracle ORA-00984: column not allowed here
- column not allowed here
- ORA-02287: sequence number not allowed here
- ORA-02287: sequence number not allowed here解决
- magento:DirectoryIndex not allowed here
- insert into...select from...ORA-02287: sequence number not allowed here问题
- ORA-02287:此处不允许序号(sequence number not allowed here) 的避免以及强制实现
- ORA-02287:此处不允许序号(sequence number not allowed here) 的避免以及强制实现
- element filtername is not allowed here
- listener Element listener-calss not allowed here
- Element multipart-config is not allowed here
- element filter-name is not allowed here
- element listener-class is not allowed here
- ORA-24323: value not allowed ORA-01089
- Delphi - 关于错误E2002 File Type is not allowed here
- error: a function-definition is not allowed here before ‘{’ token
- 蹭网卡与一键配对EasyLink技术
- C++ 学习小记
- 有关android Socket编程 在两个模拟器中实现
- Selenium Webdriver元素定位的八种常用方式
- Fragment生命周期
- ORA-01733: virtual column not allowed here
- JAVA动态代理(拦截器)
- python webapp2 redirect
- 微信公众号开发 调用图灵机器人的接口使自己的微信成为一个智能机器人
- 日期和数字字符串的格式化
- [LeetCode]Same Tree
- mongodb查询
- Android逆向分析之dex2jar异常处理
- 浅谈Borg/YARN/Mesos/Torca/Corona一类系统