ORA-00604递归SQL级别1出现错误

yihanehan

对表进程字段删除时，出现这个错误，
执行的sql是alter table INF_IMP.WM_J_TASK_ORDER drop column order_id;

请刘大，帮我看看

lixiaxin200319

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.

视图的虚拟列不能删除，你要在基表上做删除列的操作。

lixiaxin200319

delete/Update/insert 视图时，如果视图有分组函数、GROUP BY 子句、DISTINCT 关键字、ROWNUM 等伪列、常量表达式这些时，是不能修改视图的。