Make a partition ready only(12CR2) - Oracle Database Script. -- From oracle 12.2.0.1 Relase, we can make few partitions of a table read only. SQL> alter table dbatest.ORDER_TAB modify partition CREATED_2105_P10 read only; Table altered. SQL> select partition_name,read_only from dba_tab_partitions where table_name='ORDER_TAB'; PARTITION_NAME READ -------------------------------- ---- CREATED_2105_P10 YES CREATED_2105_P11 NO CREATED_2105_P12 NO CREATED_2105_P8 NO CREATED_2105_P9 NO CREATED_MX NO 6 rows selected.
-- From oracle 12.2.0.1 Relase, we can make few partitions of a table read only. SQL> alter table dbatest.ORDER_TAB modify partition CREATED_2105_P10 read only; Table altered. SQL> select partition_name,read_only from dba_tab_partitions where table_name='ORDER_TAB'; PARTITION_NAME READ -------------------------------- ---- CREATED_2105_P10 YES CREATED_2105_P11 NO CREATED_2105_P12 NO CREATED_2105_P8 NO CREATED_2105_P9 NO CREATED_MX NO 6 rows selected.