Please follow the below steps listed in Options 1 or 2 to resolve this problem.
Option 1 - To increase the MAX VALUE:
- Login with oracle with sys user
Check the max value of the sequences in the following line:
SQL>select sequence_owner, maxvalue from dba_sequences where sequence_name='<sequence-name>'
- Change the MAXVALUE of the sequence. The sequence owner will then be checked from this query.
Alter the sequence as follows:
<sequence-owner>.<sequence-name> MAXVALUE xxxx;
Option 2 - Reset the sequence to return to the START VALUE:
Reset the sequence to go back to the START VALUE. When you alter a sequence with the CYCLE option, you are saying that, when the sequence reaches its MAXVALUE, it will start over at the MINVALUE. To alter the sequence, modify the following string:
A sequence is an object in Oracle that is used to generate a number sequence in a descending or ascending order. This can be useful when you need to create a unique number to act as a primary key. As depicted from the error message, this occurs when a sequence exceeds the MAXVALUE defined for that sequence. In such cases you have many options on the basis of your requirements, either you can increase the MAXVALUE or the reset the current value of the sequences.