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;
/
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;
alter table tq84_x read write;
Cleaning up:
drop table tq84_x;