Oracle Sequence Modification

During project creation, Oracle database migration may occur, and the sequence may be reset. As a result, when the current value of the sequence is smaller than the maximum value of the field in the table using the sequence, an error occurs,

[DH-OFFICE] 19:48:32 warn [http-8080-5] jdbcexceptionreporter. logexceptions (100) | SQL error: 1, sqlstate: 23000 [DH-OFFICE] 19:48:32 error [http-8080-5] jdbcexceptionreporter. loghoptions (101) | ORA-00001: violates a unique constraint (dhoffice. pk_app_user)

Modify the sequence value:

Maximum query value

Select max (userid) from userinfo

Add 100 to the original maximum value
Alter sequence s_app_user increment by 100;

Done!