error says that if you have a MAXVALUE already you will need to either
drop the partition that encompasses the MAXVALUE or split partition
partmax at (XXX)
(partition partXXX, partition partmax);
The docs note this on the ORA-14074 error:
ORA-14074 - partition bound must collate higher than
that of the last partition
Cause - Partition bound specified in
ALTER TABLE ADD PARTITION statement did not collate higher than that of
the table's last partition, which is illegal.
Action - Ensure
that the partition bound of the partition to be added collates higher
than that of the table's last partition.