Adding Change Data Capture to Oracle 9i LOgical Standby Database

From: <dbaplusplus_at_hotmail.com>
Date: 30 Apr 2006 13:47:02 -0700
Message-ID: <1146430022.857703.226430@y43g2000cwc.googlegroups.com>

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. Received on Sun Apr 30 2006 - 15:47:02 CDT