Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
