Search notes:

Oracle: Read-only tables

Tables can be set read-only.

create table tq84_table (
  col_1 number,
  col_2 date
);

insert into tq84_table values (1, sysdate);

Making the table read only:

alter table tq84_table read only;

Verify that the table is read only in the data dictionary:

select read_only from user_tables where table_name = 'TQ84_TABLE';

insert into tq84_table values (2, null);

Cleaning up:

drop table tq84_table purge;

See also