Search notes:

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

create table tq84_A (id number, txt varchar2(10));

insert into tq84_A
select
   level,
   dbms_random.string('a', 10)
from
   dual connect by level <= 20;
  
commit;
The following update statement runs ok …
update (
   select id
   from   tq84_A
)
set id = 1000 + id
where
   rownum <= 5;
-- --: ORA-01732: data manipulation operation not legal on this view -- … but this one ends in a ORA-01732: data manipulation operation not legal on this view error:
update (
   select   id
   from     tq84_A
   order by txt
)
set id = 1000 + id
where
   rownum <= 5;  
Cleaning up:
drop table tq84_A;

See also

ORA-01779: cannot modify a column which maps to a non key-preserved table
Other Oracle error messages

Index