From Oracle Database 12c Release 2 (12.2) onward you can mark partitions and subpartitions as read-only to protect their data from accidental change. - Read-Only Partitions - Read-Only Subpartitions Related articles. A partitioned table can be created with read-only partitions by specifying the clause at the partition level in the statement. Alternatively the table can be created as read-only, with some partitions marked as read-write by exception. The status of a partition can be switched using the ALTER TABLE statement. Attempting to insert into a read-only partition results in an error. A subpartitioned table can be created with read-only subpartitions by specifying the clause at the subpartition level in the statement. Alternatively the table or partition can be created as read-only, with some subpartitions marked as read-write by exception. The status of a subpartition can be switched using the ALTER TABLE statement. Attempting to insert into a read-only subpartition results in an error. For more information see: Hope this helps. Regards Tim...