Re: Sequence Number

From: Arlette BROSSARD <abray_at_club-internet.fr>
Date: Fri, 21 May 1999 11:14:10 +0200
Message-ID: <7i3878$91h$1@front6m.grolier.fr>

It can be a way (I work with Oracle 7.3).

Look at DBA_SEQUENCES or ALL_SEQUENCES or USER_SEQUENCES. If CACHE_SIZE is > 0 (probably 8 in your case), you can modify your = sequence with ALTER SEQUENCE.
For example :

SQL> SELECT cache_size FROM user_sequences WHERE sequence_name = = 'IDERR'; CACHE_SIZE

SQL> ALTER SEQUENCE iderr NOCACHE;

Séquence modifiée.

SQL> SELECT cache_size FROM user_sequences WHERE sequence_name = = 'IDERR'; CACHE_SIZE

nsprint_at_novasprint.com.my a écrit dans le message = <3745106E.FB899A31_at_novasprint.com.my>...
>Hi,
>
>Can anyone help me on this?
>
>I've some problem on Sequence in Oracle 8.
>
>There is a "gap" in the retrieval of sequence number from a Sequence
>Table created in Oracle8.
>Eg. The last sequence number retrieved yesterday was 23 but today when
>testing the same function to retrieve the next sequence, it jumped to
>31!!
>
>Can anyone give me some solution on this issue?
>
>Thanx in advance.
>
>Best regards
>HW
>
>
Received on Fri May 21 1999 - 04:14:10 CDT