alter table modify a partition

Right now, the PARTITION  TABLE_2007_12  VALUES LESS THAN (MAXVALUE).  I like to change the MAXVALUE to  2007, 12 so I can add more partitions for year 2008.  How to make the following work?  Thanks.
alter table TEST  modify  PARTITION TABLE_2007_12 VALUES LESS THAN (2007, 12)   ;


ewang1205Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ewang1205Author Commented:
Looks like I have drop that 2007, 12 partition and recreate one and recreate all the indexes.
0
ewang1205Author Commented:
Looks like I have to drop that 2007, 12 partition and recreate one and recreate all the indexes.  Looks like that drop/create is my only option.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

sventhanCommented:
Yeah you're right. I do not find any alter table modify partition command either.
0
sventhanCommented:
You could only do the following operations with the partitioned table.                      

      Adding Partitions
      Coalescing Partitions
      Dropping Partitions
      Exchanging Partitions
      Merging Partitions
      Moving Partitions
      Renaming Partitions
      Splitting Partitions
      Truncating Partitions
0
sventhanCommented:
is it a list or range partition?
0
jwittenmCommented:
If it is a range partition (and it looks like it is) and this is the upper end (it must be) then you can split the partition.
0
ewang1205Author Commented:
For now, I will drop and recreate the partition.  Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.