Re: Capturing Schema changes ??

From: Natural Join B.V. <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 12 Jul 2004 18:42:19 MET
Message-Id: <20040712164238.B81F09707B5@ha-smtp0.tiscali.nl>

search for CDC (Change Data Capture) which is only available in the synchronous mode (based on triggers) but in 10g there is also support for asynchronous CDC. Under the covers, is it using a mixture of Streams, LogMiner, and CDC. I believe it is explained in the DataWarehouse Guide, and the related packages are documented in the Supplied Packages Reference.

cheers,
Lex.

> In the recent IOUG Conf there was a presentation that discussed how to do this
> using Oracle Streams.
>
> Regards,
>
> - Kirti
>
> --- "Leonard, George" <GLeonard_at_wesbank.co.za> wrote:
> > Hi all
> >
> > We are in need of a solution to capture all changes to a schema, table
> > creates, alters drops,
> > procedure creates...
> > functions, views, indexes etc etc.
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 12 2004 - 12:09:27 CDT