All Forums Database
13 Feb 2016
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:
dnoeth 4628 posts Joined 11/04
14 Feb 2016

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

Dieter

14 Feb 2016

Thanks for replying Dieter.. :)

You must sign in to leave a comment.