-
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
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
|