Menu
This error is happening when I'm trying to insert values on a table belong to the user which I'm using:
SQL Error: ORA-01732: data manipulation operation not legal on this view
*Cause:
*Action:
In all the places the people say that it occurs when trying to insert/update/delete on a view, but it is certainly a table, and the user has the privileges needed.
So, there is any other cause for this happening beyond trying to do ilegal operation with a view?
528
The manipulation operations involves like to SELECT, INSERT, DELETE and UPDATE the data into the SQL database. SELECT - We can select one or more data from the table.
Data manipulation language (DML) statements add, change, and delete Oracle Database table data. A transaction is a sequence of one or more SQL statements that Oracle Database treats as a unit: either all of the statements are performed, or none of them are.
In computing, a materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary using an aggregate function.
To update the data in a materialized view, you can use the REFRESH MATERIALIZED VIEW statement at any time. When you use this statement, Amazon Redshift identifies changes that have taken place in the base table or tables, and then applies those changes to the materialized view.
An alternative answer: I came across this error when I tried to INSERT a record into a materialized view table.
200
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
