How Oracle Reset Sequenceby Ed ChenSeptember 23, 2020December 9, 2022Reset a Sequence with Original NEXTVAL There're two way to reset sequence to exact number you want in Oracle: 1. Start Sequence to Exact Number… Read More »How Oracle Reset Sequence
How to Resolve ORA-08002: sequence CURRVAL is not yet defined in this sessionby Ed ChenJune 8, 2020December 10, 2022ORA-08002 ORA-08002 means that you don't have any sequence value cached in your session, so you can't check the current value (CURRVAL) of the sequence… Read More »How to Resolve ORA-08002: sequence CURRVAL is not yet defined in this session