Re: Question about adding partitions to a table?
Hi,
Yes, I believe you would end up getting the
ERROR 1481 (HY000): VALUES LESS THAN value must be strictly increasing for each partition
message if you attempted to add a partition if you've previously included a MAXVALUE partition. Should that be absolutely necessary, I suppose you could copy the contents of the maxvalue partition to a temporary table, drop it and then add another partition and copy the data back again.
Regards,
Erik Ljungstrom
Subject
Views
Written By
Posted
4980
January 03, 2008 04:30PM
2879
January 04, 2008 01:50AM
Re: Question about adding partitions to a table?
2975
January 04, 2008 04:39AM
2783
January 15, 2008 02:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.