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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
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
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width