PPI Dropping/Adding Partitions

Database
Enthusiast

PPI Dropping/Adding Partitions

Hello All,

What is the query to drop and add CASE_N and KEY for PPI?.

I was able to drop and add range_n whereas when i tried for CASE_N and KEY i was not able to either add or drop the PPI.

Thanks in Advance

Tags (1)
2 REPLIES
Junior Contributor

Re: PPI Dropping/Adding Partitions

You can't DROP/ADD/MODIFY a CASE_N-partitioning (unless the table is empty).

Enthusiast

Re: PPI Dropping/Adding Partitions

Thanks for replying Dieter.. :)