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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Replication

Re: Replication

From: Graham Bellamy <dontwriteme_at_ask.first.com>
Date: Wed, 29 May 2002 03:25:28 +1000
Message-ID: <ad0ebd$551$1@perki.connect.com.au>


"David Kerber" <ns_dkerber_at_ids.net> wrote in message news:3CF3B054.BD51137B_at_ids.net...
> Another way to handle this might be to add a field to your quotes table
> called something like Previous_Ver which contains just the pkey
> reference to the previous version of this particular quote number.
> Then you can walk the tree of previous_ver values from the most recent
> to the original version of the quote, no matter how many revs it goes
> through.

Thanks. I think this should be able to be done with both methods I mentioned (1001,1007 & 1001-1, 1001-2).

Any comments about the duplication of the entire record (and all its related child records)?
In appreciation,
Graham Received on Tue May 28 2002 - 12:25:28 CDT

Original text of this message

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