Partition => 12cR2 New Feature "Read-Only Partition/Subpartition"

With 12cR2, now you can create or modify your partitions/subpartitions as "READ ONLY" and prevent them against DML operations.


CREATE TABLE list_hash_tab (
  id           NUMBER,
  code         VARCHAR2(10),
  description  VARCHAR2(50),
  created_date DATE
)
PARTITION BY LIST (code)
SUBPARTITION BY HASH (id)
(
   
   PARTITION part_aa values ('AA')
   (
      SUBPARTITION part_aa_01, SUBPARTITION part_aa_02),
   
   partition part_bb values ('BB')
   (
      SUBPARTITION part_bb_01, SUBPARTITION part_bb_02)
);


alter table list_hash_tab modify partition part_aa read only;

alter table list_hash_tab modify subpartition part_bb_01 read only;