ORA-00604递归SQL级别1出现错误
本帖最后由 yihanehan 于 2015-4-17 17:33 编辑对表进程字段删除时，出现这个错误，
执行的sql是alter table INF_IMP.WM_J_TASK_ORDER drop column order_id;
请刘大，帮我看看 Error: ORA 1732
Text: data manipulation operation not legal on this view
-------------------------------------------------------------------------------
Cause: An attempt was made to use an UPDATE, INSERT, or DELETE statement on a
view that contains expressions or functions or was derived from more
than one table.
If a join operation was used to create the view or the view contains
virtual columns derived from functions or expressions, then the view
may only be queried.
Action: UPDATE, INSERT, or DELETE rows in the base tables instead and restrict
the operations on the view to queries.
视图的虚拟列不能删除，你要在基表上做删除列的操作。
delete/Update/insert 视图时，如果视图有分组函数、GROUP BY 子句、DISTINCT 关键字、ROWNUM 等伪列、常量表达式这些时，是不能修改视图的。
页:
[1]