I cannot add a table partition in Oracle to an existing table in Toad.
说明
Im trying to alter a partition in Oracle. If I open the ALTER table window in Toad and try to click on the Add button, it is grayed out.
原因
Caused by anyone of the partition in a table having a upper bound of MAXVALUE.
解决办法
This is an Oracle restriction dealing with MAXVALUE. Oracle will not allow for a partition to be added into the middle of a range. You can try to "split" the MAXVALUE partition or to rebuild the table.
