Oracle Magazine, September/October 2017
DBA PERFORMANCE After running this statement if you attempt to update the data in that subpartition you will get an error insert into accounts values 3 C CT 4000 1 jul 2015 ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 91 ERROR at line 1 ORA 14466 Data in a read only partition or subpartition cannot be modified Of course you can revert the subpartition to the read write state by using the same ALTER command with READ WRITE instead of READ ONLY to allow rows to be inserted into the subpartition This ability to make a partition or subpartition read only or read write is not just for the ALTER statement You can also specify the read attribute of the partition when the table is created as shown in Listing 6 Code Listing 6 Creating read only partitions create table accounts acc_ no number acc_ type varchar2 1 state_ code varchar2 2 acc_ balance number last_ trans_ dt date partition by range last_ trans_ dt subpartition by list state_ code
You must have JavaScript enabled to view digital editions.
