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
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.
Try with this
UPDATE MYTABLE PARTITION(PART_MAY2002)
You will have to use "alter table ... split partition".
spilt 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