Oracle Magazine, September/October 2017
DBA PERFORMANCE If the index After the conversion operation on the Its very important to understand how the indexes on the table will change as a result of the conversion from an unpartitioned table to a partitioned one and write the UPDATE INDEXES clause appropriately Note that while you can influence the physical attributes of an index to some extent you cannot change its design For example you cant convert a nonunique index to a unique one or vice versa with the UPDATE INDEXES operation ONLINE SPLITTING Conversion to a partitioned table is a onetime activity for a table and you probably will do a lot more with a partitioned table such as splitting partitions Even partition splitting operations are now available online with Oracle Database 12c Release 2 To see splitting in action lets first create a partitioned table called ACCOUNTS and insert some rows as shown in Listing 8 ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 101 Code Listing 8 Range partitioned table for splitting create table accounts acc_ no number table the index becomes Does not contain the column on which the table is being partitioned Unpartitioned Contains the column on which the table is being partitioned Locally partitioned Is a bitmap index regardless of the column it is on Locally partitioned
You must have JavaScript enabled to view digital editions.