ORA-01732: data manipulation operation not legal on this view

[holdingbe]

Hi all,

During the update the views it shows ORA-01732: data manipulation operation not legal on this view error. this view created by only one table.



please help me....


Thanks and regards
Michael

[amitpatel66]

THE VIEW IS MATERIALIZED VIEW so u cannot perform DML on them. They will get REFRESHED automatically based on REFRESH options specified for this materialized view.

[holdingbe]

THE VIEW IS MATERIALIZED VIEW so u cannot perform DML on them. They will get REFRESHED automatically based on REFRESH options specified for this materialized view.

Hi...
Thanks for reply ... but that view is not materialized view.This view is normal view. this view created based on a one tables


Thanks and regards
Michael Holding

[amitpatel66]

There are several options to why u r not able to perform DML on the Normal View:

1. If the View contains derived expressions or functions. As u said the table is only one or else that could have been another reason.
2. Check if you have proper INSTEAD OF TRIGGER on the View.
Say in case if the INSTEAD OF TRIGGER is only for INSERT,UPDATE, then U will not be able to DELETE from a view.
3. IF the View uses ORDER BY Clause, then it makes the View Read only one.

[debasisdas]

please check if the view is a read only one.

[aarbhargavi]

Hi all,

During the update the views it shows ORA-01732: data manipulation operation not legal on this view error. this view created by only one table.



please help me....


Thanks and regards
Michael

hai can u pls give the create view statement and also the table structure.