In 12.2 a partition or sub-partition can be marked as READ ONLY at the time of creation (CREATE TABLE) or later (ALTER TABLE).

It must specify key word READ ONLY. READ WRITE is the default.

 

Example 1: (yxy is partitioned table)

SQL>ALTER TABLE yxy READ ONLY;
All current and future created partitions will be read only.

Example 2:

SQL>ALTER TABLE yxy MODIFY PARTITION yxy_p4 READ ONLY;
All partitions except yxy_p4 are read only.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.