2 Replies Latest reply: Jan 7, 2013 5:40 AM by Osama_Mustafa RSS

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

    966337
      Hi All,

      While updating we are getting error ORA-01732: data manipulation operation not legal on this view.
      I checked the object type one is table and another is materialized view.

      Can you please share your suggestions.

      Thanks
        • 1. Re: ORA-01732: data manipulation operation not legal on this view
          GReboute
          Hi,
          You tried to udate a view altough it is contructed with (from documentation) :

          You cannot update a view except with INSTEAD OF triggers if the defining query of the view contains one of the following constructs:

          A set operator
          A DISTINCT operator
          An aggregate or analytic function
          A GROUP BY, ORDER BY, MODEL, CONNECT BY, or START WITH clause
          A collection expression in a SELECT list
          A subquery in a SELECT list
          A subquery designated WITH READ ONLY
          Joins, with some exceptions, as documented in Oracle Database Administrator's Guide
          • 2. Re: ORA-01732: data manipulation operation not legal on this view
            Osama_Mustafa
            Error: ORA 1732
            Text: 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.
            Action: UPDATE, INSERT, or DELETE rows in the base tables instead and restrict
            the operations on the view to queries.