Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Replication / Offline Template instantiation / Sequences
Folks,
I'm in the middle of a project where some 150 laptops
need to be replicated from a main server. The C/S app
that runs off the main server is kind of duplicated
to the laptops (less functionality on laptop than in
C/S env.).
No problem so far.
Because of the sheer amount of portable clients, and the fact hortizontal partitioning is used, rollout should be using a template, preferably instantiated offline (online is an option).
Problem is, that there are a couple of sequences (sequences cannot be replicated!), for which the following resolution was inveted: every client sequence gets upped by 200 (main server too!), but gets it's own unique starting point. So: client 1 starts at 120001, client 2 starts at 120002, 3 at 120003, etc, etc.
Question is: how do I code that into a template? How do I know which clients are actually rolled out when rolling out (e.g. laptop # 200 is the 7th client being rolled out, so the sequence would have to start at 120007)
All ideas welcome (including other sequence problem resolvers, as long as I do not have to change from number to varchar2)
-- Gtrz, Frank van BortelReceived on Wed Jan 23 2002 - 13:37:13 CST
![]() |
![]() |