Oracle Magazine, September/October 2017
DBA PERFORMANCE IN_ ACC_ TYPE P2015_ CT UNUSABLE IN_ ACC_ TYPE P2015_ DEF UNUSABLE IN_ ACC_ TYPE P2015_ NY UNUSABLE IN_ ACC_ TYPE P2016_ CT USABLE IN_ ACC_ TYPE P2016_ DEF USABLE IN_ ACC_ TYPE P2016_ NY USABLE IN_ ACC_ TYPE P2017_ CT USABLE IN_ ACC_ TYPE P2017_ DEF USABLE IN_ ACC_ TYPE P2017_ NY USABLE Note that the status of the split subpartitions is UNUSABLE This is expected and you should rebuild the index subpartitions Alternatively you could have used the UPDATE INDEXES clause in the ALTER TABLE SPLIT PARTITION statement to have Oracle Database take care of this at the time of the split ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 105 alter table accounts split partition p2015 into partition p2014 values less than to_ date 01 jan 2015 dd mon yyyy partition p2015 update indexes
You must have JavaScript enabled to view digital editions.