Re: Adding Change Data Capture to Oracle 9i LOgical Standby Database

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 01 May 2006 14:45:07 -0700
Message-ID: <1146519912.373047@jetspin.drizzle.com>

dbaplusplus_at_hotmail.com wrote:
> I am using Oracle 9.2.0.6 on HP UNIX 11i. I will be setting a logical
> standby database for reporting. In addition, I want to add Oracle's
> Change Data Capture (CDC) to logical standby database. CDC adds new
> triggers to existing tables (not in primary database) as well as adding
> new tables (not in primary database).
>
>
> Even though, sql apply of logical standby database skips triggers and
> constraints, CDC triggers will still work because they are only logical
> standby database. Does any one see problem with using CDC in this
> configuration.
>
>
> Thanks.

There are three different ways to configure CDC. Why are you choosing synchronous rather than asynch?

Daniel Morgan
www.psoug.org Received on Mon May 01 2006 - 16:45:07 CDT