ewang1205
asked on
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) ;
alter table TEST modify PARTITION TABLE_2007_12 VALUES LESS THAN (2007, 12) ;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
is it a list or range partition?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
For now, I will drop and recreate the partition. Thanks.
ASKER