Alex Rivera | Logout

"data manipulation operation not legal on this view" happening in a user table

Asked 2011-09-16T12:53:30.917
9

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?

oracle-database
Edit
Report

1 Answer

3

First thing: are you really sure it is a table? From the way you have framed the question it might be that the user experiencing this problem doesn't own the table. In which case, perhaps there's a synonym or something which is really pointing at a view.

Second thing it might be, is if there's a trigger on the table and it is the action it fires causing the problem.

answered 2011-09-16T13:03:40.690

Your Answer