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.