Re: HOW TO SET SEQUENCE VALUE

  • From: jose soares <jose.soares@xxxxxxxxxxxxxx>
  • Date: Thu, 29 Mar 2012 16:26:51 +0200

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


Other related posts: