Re: HOW TO SET SEQUENCE VALUE

From: jose soares <jose.soares_at_sferacarta.com>
Date: Thu, 29 Mar 2012 16:26:51 +0200
Message-ID: <4F74712B.1000004_at_sferacarta.com>

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.
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 29 2012 - 09:26:51 CDT