Hi,
Using 11.2.0.3 and following sql
select last_number
from user_sequences u
where u.SEQUENCE_NAME ='<sequence_name>'
This alst_number ios actually the number which would be retrieved by doing
select sequence_name.nextval
from dual
Why is this ths case - why is last_number not the actual_last number used.
On this basis looks like we would need to use last_number -1 to get the real last number used