On Mon, Sep 22, 2008 at 10:29:13AM -0400, Knight, Doug wrote:
> Andrew,
> How would you handle a sequence that is accessed by more than one table?
> We have an audit sequence that is accessed from most of our tables, so
> combining the sequence into a single table set with all accessing tables
> will make for a very large table set.

Pick one.  It doesn't actually matter -- the sequences are not really
replicated perfectly anyway.  Instead, the sequence is advanced on the
replica to the current value of the sequence at replication time.
This means that the sequences can be logically further ahead on the
replica than on the origin.  This is ok by the semantics of the
sequence, which can be gappy but is not allowed to go backwards.

A

-- 
Andrew Sullivan
ajs at commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/