How to solve Oracle Database Error 1732 (ora-01732)

Oracle Error Code
   ora-01732

Description
   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.
How to Solve
   UPDATE, INSERT, or DELETE rows in the base tables instead and restrict the operations on the view to queries.
Posts About Oracle Database Error ORA-01735
Michael:
Views cannot always be updated, and it is understandable 
because a view is basically a select statement not a storage object.


Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-01632    ORA-01633    ORA-01634    ORA-01732    ORA-01733    ORA-01734    ORA-01735  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares