Oracle Magazine, September/October 2017
DBA PERFORMANCE ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 97 partition p5000 values less than 5000 partition pmax values less than maxvalue Note the ONLINE keyword in this ALTER statement which results in the table being converted online Now check the table for partitions select partition_ name high_ value from user_ tab_ partitions where table_ name ACCOUNTS PARTITION_ NAME HIGH_ VALUE P1 CT SYS_ P1103 NY Thats it The table has been converted to a partitioned one all online The UPDATE INDEXES clause updates the indexes as a part of the operation Now lets see the impact of the different index options on this newly converted partitioned table First lets see if the indexes are partitioned by using the following SQL statement
You must have JavaScript enabled to view digital editions.