Oracle Magazine, September/October 2017
DBA PERFORMANCE ORACLE DATABASE 12c RELEASE 2 Automatic and Easy Oracle Database 12c Release 2 delivers better automatic multicolumn and read only partitions Partitioning has been a powerful tool for efficient management of large Oracle databases since its introduction in Oracle8 Database Oracle Database 12c Release 2 delivers some powerful new partitioning features This article explores some of these new features and how to use them AUTOMATIC LIST PARTITIONING Do you remember interval partitioning which was introduced in Oracle Database 11g It allowed you to create a partitioned table in which new partitions were automatically created on the fly when new data came in freeing you from the mundane task of constantly adding new partitions But interval partitioning applied to range partitions only With new partition support in Oracle Database 12c Release 2 you can now ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 80 create list partitions on the fly By Arup Nanda
You must have JavaScript enabled to view digital editions.