Leave a Comment:
8 comments
How to setup the publisher and subscriber on two different machines.
ReplyCan the CDC be implemented on eBusiess Suite implementation – any references?
Particularly Release 12…?
Thanks,
Srikanth
We want to implement change data capture feature on the database, so would like to know if it is done on any eBusiness implementations..?
ReplyYes you can implement CDC in EBS database : Check 370629.1 Change Data Capture (Cdc) and Oracle Applications 11i, this note is for 11i but same can be applied to R12
For more information on CDC check
http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/cdc.htm
http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_cdc_cookbook_0206.pdf (CDC cookbook)
ReplyHi
Have you implemented CDC on any of the applications.
Regards,
PKB
Hi,
I have set-up CDC using Asynchronous capture method. I wanted to understand if we remove DBA access provided to Publisher on source database and publisher on Staging data what would happen. Is there any way of implementing CDC without giving DBA access.
ReplyI am not a technical prson and have a simple question relating to CDC.
Can CDC work in Oracle R12 as itworks in 11i? H
Is there any change at all in relation to R12?
Thanks
Akwasi Appau
Hi Atul, I have a small question. I have a asyncronus auto log(archive log) CDC. Now I want to add a table to this existing change set… Please let me know if the below statement is correc.
0. Add supplemental log
1. instantiate the table being added in source DB
2. Stop capture/apply process in staging DB
3. create change table in staging DB
4. grant change table to subscription owner.
5. start the change set
6. drop & recreate subscription.