Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Streams / Change Data Capture Question

Re: Oracle Streams / Change Data Capture Question

From: DA Morgan <>
Date: Sat, 06 Oct 2007 00:31:57 -0700
Message-ID: <> wrote:
> Hi,
> I wondered if you could advise me on what Oracle feature to look into
> to help me decide upon a design issue?
> we have a corporate database - our main system - which is effectively
> the single repository for data in the organisation.
> A need for a publically available extranet has arisen, whose
> underlying database schema will contain a replica of some of the main
> system's data.
> About 10 tables have to be populated in the extranet's database. Their
> data will be derived from data stored in the main system. Some, but
> not all of these tables have a direct equivalent in the source system
> - ie the data that some tables will store is derived from a number of
> tables in our source system.
> If records in two of the tables in the main system are flagged to be
> pushed to the website's database by business users [which could happen
> at any time], it is possible to derive what the remainder of the data
> destined for the website's database should be.
> Clearly, it would be very simple to implement a push of data from the
> source to the destination database just by putting triggers on the two
> tables previously mentioned to capture changes to their records, using
> some queries to bring the data together, and then send these resulting
> datasets off to the destination system.
> The question I have is whether or not a feature like 'Oracle Streams'
> or 'Change Data Capture' would be useful in this situation? Is it
> possible to configure either of these features to recognise that when
> a change is made to a particular record, that Oracle should not only
> propogate this change to a destination system, but also propogate a
> related dataset as well? A feature like Streams would certainly
> simplify catering for situations where reference data in the main
> system changed after it was pushed to the destination.
> Any information would be appreciated,
> Cheers,
> Andrew.

CDC is a simple, basic, form of Streams. Easy to implement, easy to maintain, and little flexibility. I suspect you are looking at Streams and will need to give careful consideration to how you write your positive and negative rule sets.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Sat Oct 06 2007 - 02:31:57 CDT

Original text of this message