MAXVALUE or NOMAXVALUE Option
Use the MAXVALUE option to specify a new upper limit of values in the sequence. The maximum value, or max, must be an integer in the INT8 range that is greater than sequence.CURRVAL and restart (or greater than the origin in the original CREATE SEQUENCE statement, if restart is not specified).
Use the NOMAXVALUE option to replace the current limit with a new
default maximum of 2e64
for ascending sequences or -1
for
descending sequences.