Re: Oracle newbie needs help

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 4 Feb 2003 14:23:18 -0800
Message-ID: <3e403d56@news.victoria.tc.ca>

Testy McTest (testy_mctest_at_yahoo.com) wrote:
: Hi,

: Is there an easy way to capture all transactions done on an Oracle 8i
: database such that they could later be applied to a different Oracle
: database?

: It doesn't have to be an Oracle only solution. If there's an
: open source solution to this, I'm open to that too.

SNAPSHOTs can do this. Replication then consists of applying the same changes elsewhere

You could also use triggers to monitor the changes yourself, and then apply them later. That would make sense if you were not trying to replicate your data, but simply apply similar changes to different bases (kinda like when you apply a single source code patch to update different versions of source code). Received on Tue Feb 04 2003 - 16:23:18 CST