Hello Bp
If you use the sequence for unique identifiers
only,
you do not need to worry about this.
At most the numbers will go from 1234 to 11234
and
continue from there. So what?
Yechiel AdarMehish
- Original Message -
From:
BigP
To: Multiple recipients of list
Bigp
Remember that when you issue
sequence.nextval you are incrementing one value and eitheryour process
function corrector not that number is used.
But, the more important is that if your system
crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers
cached. Also you can
what
do you mean about losing numbers after an import/export?
-Original Message-From: Ramon E. Estevez
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 14, 2002
10:44 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: sequence question
Bigp
Remember that when you
Bill,
When you do an export you have sequence numbers
in cache.
Ramon
- Original Message -
From:
Magaliff, Bill
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 10:53
AM
Subject: RE: sequence question
what
do you mean about losing
to loose numbers
?
Did any of you guys tried caching high number such
as 1 or 100 .
Thanks ,
Bp
- Original Message -
From:
Magaliff, Bill
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 8:53 AM
Subject: RE: sequence question
what
do
Acording to the manuals SEQUENCE_CACHE_ENTRIES is an obsolete
parameter for 8.1.7
Ramon
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE-L
Sent: Friday, June 14, 2002 12:49
PM
Subject: Re: sequence question
while going throgh oracle
Short answer - yes you could loose some numbers.
Have a look at http://www.ixora.com.au/scripts/library.htm and the
unload_sequences.sql and keep_sequences.sql which mention that you can lose when:
Shutdown abort is done
the sequence gets aged out of the library cache
The