I was looking for a easy way to modify last_number but seems it is possible only using ALTER SEQUENCE Thanks any way to everyone. j Norman Dunbar wrote: > On 29/03/12 13:49, Taylor, Chris David wrote: > >> Can you clarify an instance where a NOCACHE sequence number would be lost? >> > > Any time you rollback a transaction would lose a value. (Which is > basically what you said). > > Cheers, > Norm. > > -- //www.freelists.org/webpage/oracle-l