Home » SQL & PL/SQL » SQL & PL/SQL » Need Assistance (9)
Need Assistance [message #341677] Tue, 19 August 2008 23:06 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

We need your help regarding the Change Data Capture(CDC) functionality provided by Oracle. Currently, one of our application uses the CDC functionality to capture the changes in the database and later this data is sent to other database. Some filter conditions are applied to determine what data has to be sent to other database.
However, there are at times the changed data is not sent to other database even after the filter conditions are met.
As we know after processing changed data gets deleted from CDC tables but we have to track back what data has been taken by CDC in the last run, thus we trying to figure out if CDC can offer any logging mechanism to log the data/internal manipulation it does or any thing relevant to this.

I tried searching on net but didn't get anything which can help us in this regard.

We'll really appreciate any help in this area.

Thank you.
Re: Need Assistance [message #341678 is a reply to message #341677] Tue, 19 August 2008 23:14 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

If what you report is correct & accurate, then need to produce a test case & submit a bug to Oracle.

Of course even if you succeeded in developing a reproducable test case, you efforts may be moot as the bug may have been fixed by V11.

Good Luck on solving your mystery.
Previous Topic: how to truncate a specific number range
Next Topic: replicate table in the same server
Goto Forum:
  


Current Time: Fri Dec 09 05:42:49 CST 2016

Total time taken to generate the page: 0.05249 seconds