Oracle Magazine, September/October 2017
DBA PERFORMANCE Because the values of the STATE_ CODE and ACC_ TYPE columns are CT and S respectively the inserted row should be located in the CT_ S partition Lets confirm it by selecting rows from that partition ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 87 select from accounts partition ct_ s ACC_ NO ACC_ TYPE STATE_ CODE ACC_ BALANCE 1 S CT 2000 Perfect The row went to the right partition as expected This is an example with only two columns You can define list partitioning on multiple columns to suit your specific business needs So far youve learned about two very powerful features automatic list partitioning and list partitioning on multiple columns You might now be wondering if its possible to combine these two features to create an automatic list partitioned table on multiple columns The answer is yes of course Listing 4 shows how to create the same ACCOUNTS table with automatic list partitioning on two columns STATE_ CODE and ACC_ TYPE Code Listing 4 Automatic list partitioning on multiple columns create table accounts acc_ no number acc_ type varchar2 1
You must have JavaScript enabled to view digital editions.