I have partitioned my table from SEPT. 1998 - SEPT. 2002. I did not specify the maxvalue
when I created the partition.
Assuming I accidentally dropped my JAN2001(i.e. XFL_JAN2001) partition. Now I would like to split the partition for XFL_DEC2000 partition in order to add XFL_JAN2001 partition. XFL_DEC2000 contains data.
How do I perform this partition split. Below is what I have in mind. Can any one help?
alter table football
split partition XFL_DEC2000
into (
partition XFL_DEC2000 tablespace DEC2000_TABS,
partition XFL_JAN2001 tablespace JAN2001_TBS)
parallel (degree 4)
