IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
I got ” ORA-01732: data manipulation operation not legal on this view ” error in Oracle database.
ORA-01732: data manipulation operation not legal on this view
Details of error are as follows.
ORA-01732: 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.
data manipulation operation not legal on this view
This ORA-01732 errors are related with the 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.
UPDATE, INSERT, or DELETE rows in the base tables instead and restrict the operations on the view to queries.
To solve this error, Set the _simple_view_merging to TRUE and execute SQL statement again.
ALTER SESSION SET "_simple_view_merging"=TRUE scope=both
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )
