Oracle Sequence Modification Problems

Oracle Database migration may occur during the project, so the sequence may be reset, resulting in the current value of the sequence.
When it is less than the maximum value of the field in the table that uses the sequence, an error occurs, [javascript] [DH-OFFICE] 2012-10-30 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) www.2cto.com modify the sequence Value: query the maximum value select max (userid) from userinfo to add 100 alter sequence s_app_user increment by 100 based on the original maximum value; done!