Oracle Magazine, September/October 2017
DBA PERFORMANCE Because the subpartition was created as read only the insert will fail insert into accounts values 5 S NY 3000 1 jul 2017 ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 94 ERROR at line 1 ORA 14466 Data in a read only partition or subpartition cannot be modified You can change the attribute easily using the following SQL statement alter table accounts modify partition p2017 read write Now lets insert a row with 2017 in the value insert into accounts values 5 S NY 3000 1 jul 2017 1 row created The insert went through because the subpartition is now in read write mode ONLINE CONVERSION Now that you have learned about powerful new partitioning features you might want to convert some unpartitioned tables to partitioned ones And like most organizations yours will likely want that to be done with as little downtime as possible In Oracle Database 12c Release 2 you can do that conversion online You can convert an unpartitioned table to a partitioned one even when DML statements are
You must have JavaScript enabled to view digital editions.