Click here to Skip to main content
15,890,670 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
According to our classes, we have learned that after partitioning the table into multiple partitions examples P1, P2, P3, and P4 etc. Later if we want to is it possible to split P2 into multiple partitions rather than just two partitions. If yes, then could anyone explain with an example. Thank you.

What I have tried:

We tried

SQL
ALTER TABLE SPLIT PARTITION p0 INTO 
  (PARTITION p01 VALUES LESS THAN (25),
   PARTITION p02 VALUES LESS THAN (50), 
   PARTITION p03 VALUES LESS THAN (75),
   PARTITION p04);
ALTER TABLE SPLIT PARTITION p0 INTO 
  (PARTITION p01 VALUES LESS THAN (25),
   PARTITION p02);


****BUT GETTING ERROR MESSAGE****
Posted
Updated 27-May-17 23:09pm
v3
Comments
RedDk 27-May-17 14:59pm    
What tools are you using? "SQL" is very broad and in my opinion not really a platform until it's "SQL Server" or some such thing. If SQL Server serves this discussion well, I'd suggest using the BOL reference for any further questions you have.
Maciej Los 28-May-17 5:05am    
GETTING ERROR MESSAGE is not descriptive at all!

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900