Re: Tricky ordering question

"Vladimir M. Zakharychev" <bob--nospam--_at_dynamicpsp.com> wrote in message news:e1331u$j3n$1_at_hypnos.nordnet.ru...
:
: "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:2LudnVszicLJm6jZnZ2dnUVZ_vidnZ2d_at_comcast.com...
: >
: > this will only work if only if the sequence is created with the ORDER
clause
: > (NOORDER is the default)
: >
: Mmm.... I fail to see how sequences are relevant here. Sequences
: as referred in OP's post are mere sequences of actions, not Oracle
: SEQUENCE objects. :) Besides, your comment is only relevant
: for RAC, in non-RAC databases sequence generation is always
: ordered regardless this option. OP doesn't say anything about using
: RAC either.
:
: Hth,
: Vladimir M. Zakharychev
: N-Networks, makers of Dynamic PSP(tm)
: http://www.dynamicpsp.com
:

Vlad... i don't think they are relevant, but the suggestion was made that adding one would assist in ordering the poker moves that occur in the same micro-second. you are correct, though:

according to the 9.2 manual:
ORDER is necessary only to guarantee ordered generation if you are using Oracle
with Real Application Clusters. If you are using exclusive mode, sequence numbers
are always generated in order.

similar comment in 8.1.7 (s/RAC /Parallel Server/)

thanks for the correction... guess it would still be a real good idea, though, to user the ORDER clause if the sequence is expected to be returned in order so that a DB reconfig doesn't break the design.

++ mcs Received on Thu Apr 06 2006 - 08:23:43 CDT