Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Replication / Offline Template instantiation / Sequences

Replication / Offline Template instantiation / Sequences

From: Frank van Bortel <fbortel_at_home.nl>
Date: Wed, 23 Jan 2002 20:37:13 +0100
Message-ID: <3C4F10E9.53F50DA1@home.nl>


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 Bortel
Received on Wed Jan 23 2002 - 13:37:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US