DBA Hub

📋Steps in this guide1/1

Make a partition ready only(12CR2)

-- From oracle 12.2.0.1 Relase, we can make few partitions of a table read only.

oracle configurationintermediate
by OracleDba
12 views
1

Make a partition ready only(12CR2)

-- From oracle 12.2.0.1 Relase, we can make few partitions of a table read only.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
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.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!