-
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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".
Jeff Hunter
-
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
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|