Modify Partition

I have a partition table that is partitioned by date. the last partition has a high value of 6/1/02. I want to change that to 8/1/02. How do I do it? Here is what I think:

alter table mytable
modify partition PART_MAY2002
high_value to_date('20020801','YYYYMMDD');

Here is the error I get
*
ERROR at line 3:
ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

The valid options you can use in ALTER TABLE MODIFY PARTITION are PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, BACKUP, ALLOCATE EXTENT, or DEALLOCATE UNUSED.

Hi,

Try with this

UPDATE MYTABLE PARTITION(PART_MAY2002)
SET high_value=to_date('20020801','YYYYMMDD');

Cheers

Angel

You will have to use "alter table ... split partition".

Can you be more specific on split partition please???

Based on the original post requirenments I think what realy needs to be done here is:

- add new partition with new high value (8/1/02)
- merge both partitions into one using ALT#ER TABLE MERGE PARTITION clause