ORA-42399: cannot perform a DML operation on a read-only view
What triggered the Error:
An attempt was made to insert, delete, or update row(s) of a view created with read-only option. DML operations on such views are explicitly prohibited.What should we do to fix it:
Perform the desired DML operation on the view's underlying base table or issue ALTER VIEW ... READ WRITE command to make the view updatable.