AW: sequence question

2005-06-29 Thread Anhaus, Thomas
Robert Klemme wrote : >"Anhaus, Thomas" <[EMAIL PROTECTED]> schrieb am 28.06.05 08:55:26: >> I assume your sequence has been created with CACHE 100. The CACHE >> parameter defines the >> number of sequence values which are stored in the sequence cache. > >Interestingly documentation for Oracle mod

Re: sequence question

2005-06-29 Thread Robert Klemme
"Anhaus, Thomas" <[EMAIL PROTECTED]> schrieb am 28.06.05 08:55:26: > I assume your sequence has been created with CACHE 100. The CACHE > parameter defines the > number of sequence values which are stored in the sequence cache. Interestingly documentation for Oracle mode says about creating seque

AW: sequence question

2005-06-27 Thread Anhaus, Thomas
Norbert Felde wrote : > >Hi! > >If there is a system crash could sequences skip some number? >For example: >Before system crash the value of seq_main is 1000 and after >the restart >it is 1100. >If it can happen, what is to do to avoid it? > >Thanks >Norbert > >-- >MaxDB Discussion Mailing List

sequence question

2005-06-27 Thread Felde Norbert
Hi! If there is a system crash could sequences skip some number? For example: Before system crash the value of seq_main is 1000 and after the restart it is 1100. If it can happen, what is to do to avoid it? Thanks Norbert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.