Oracle Magazine, September/October 2017
DBA PERFORMANCE Now create two indexes to show the effect of the split on the indexes create index in_ acc_ balance on accounts acc_ balance local create index in_ acc_ type on accounts acc_ type local Note that the ACCOUNTS table has one partition for each year with the p2015 partition holding values of 2015 and earlier Now suppose you want to split the p2015 partition into two partitions the original p2015 partition containing only 2015 values and a new one called p2014 containing all 2014 and earlier values This SQL statement ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 103 accomplishes that objective alter table accounts split partition p2015 into partition p2014 values less than to_ date 01 jan 2015 dd mon yyyy partition p2015 However this SQL statement also creates two problems First this operation needs an exclusive lock on the table so DML statements cant run against the table at the same time This means you would have to stop your applications for the duration of the operation
You must have JavaScript enabled to view digital editions.