Add partitions to multi-level ppi

Database

Add partitions to multi-level ppi

We have a table defined as follows:

CREATE MULTISET TABLE dw_dev.rfk_IMP

……..

PRIMARY INDEX ( v_ID )

PARTITION BY ( RANGE_N(YEAR_MONTH  BETWEEN 201205  AND 201212  EACH 1 , NO RANGE, UNKNOWN),

                        RANGE_N(DATE_ID  BETWEEN DATE '2012-05-01' AND DATE '2012-12-31' EACH INTERVAL '1' DAY , NO RANGE, UNKNOWN),

                        RANGE_N(WEB_PAGE_TYPE_ID  BETWEEN 2000  AND 2300  EACH 1 , NO RANGE, UNKNOWN)

                      )

INDEX SI_CUSTID ( CUSTOMER_ID );

How do we extend the partitions for level 1 and level 2?

1 REPLY
Enthusiast

Re: Add partitions to multi-level ppi

Can you be more specific ? What exactly you want to extend ? The interval of the partition ?