Search notes:

ORA-12081: update operation not allowed on table ‥

create table tq84_x(a number);

begin
   insert into tq84_x values (1);
   insert into tq84_x values (2);
   insert into tq84_x values (3);
   commit
end;
/

Making the table read-only:

alter table tq84_x read only;

Each of the following statements throws ORA-12081: update operation not allowed on table "RENE"."TQ84_X":

insert into tq84_x values (-1);
delete from tq84_x where a > 10;
delete from tq84_x where a = 1;
update tq84_x set a = 5 where a = 3;

Enable DML again:

alter table tq84_x read write;

Cleaning up:

drop table tq84_x;

ORA-12081: update operation not allowed on table ‥

See also