This discussion is archived
2 Replies Latest reply: Jan 7, 2013 3:40 AM by Osama_Mustafa RSS

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

966337 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points