Re: Capturing Schema changes ??
- From: Natural Join B.V. <lex.de.haan@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 12 Jul 2004 18:42:19 MET
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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
