wizofoz2k_at_yahoo.com.au (Noons) wrote in message news:<73e20c6c.0409270435.74f79ae1_at_posting.google.com>...
> john_miller_portland_at_hotmail.com (John Miller) wrote in message news:<7cca1f45.0409261934.4fa2fdc_at_posting.google.com>...
>
> > You may want checking this article:
> > http://www.wisdomforce.com/dweb/resources/docs/advanced_replication.pdf.
> > It covers a lot of useful stuff and will answer your questions
>
> Nice doc, but it's as wrong as can get with the sequences.
> Ranges of numbers is the *wrong* way to use sequences in
> Oracle replication. "Start with" and "increment by" is the
> way to go. There is a thread in asktom that explains how to do
> it.
This idea has a lot of disadvantages comparing to creating several
different ranges with large gap. Read this in that
http://www.wisdomforce.com/dweb/resources/docs/advanced_replication.pdf
again on WisdomForce web site. The article says why.
Received on Wed Oct 06 2004 - 17:01:04 CDT
