oracle set sequence value to max(id)
SELECT LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_NAME = 'seq_name'; ALTER SEQUENCE seq_name INCREMENT BY 100; -- Value to reach desired value - 1 SELECT seq_name.nextval FROM dual; -- Reinitialize value to desired ALTER SEQUENCE seq_name INCREMENT BY 1; -- Back to init step