Modify Partition

[lesstjm]

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

[julian]

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

[aarroyob]

Hi,

Try with this

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

Cheers

Angel

[marist89]

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

[lesstjm]

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

[jmodic]

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