I am testing the Change Data Capture and for the most part I am able to get it working.
I have the following issues/questions. 1. I published 3 columns out of 9 column table and subscribed those 3 columns. When I make a change to the columns that were not published/subscribed, I see change records in the Change table and getting the change record in the subscriber view. Is that the way it suppose to work. I thought I should not see the changes to those records because I have not subscribed to those columns. Is there anyway we could set it up so that we only see the change records for the columns we subscribed are modified. 2. Is it possible to create a change on the Target(destination) database? I am aware that there is a performance overhead on the source system application because it has to insert the records across the databases. But, We would like to know whether it is possible? 3. If we want to fetch all the records in the change table (not just the changed records), How do I set it up so that it can read from earliest SCN in the change table. Another question related to this is, How do I read the change table from certain date timestamp? There is a packaged procedure called dbms_cdc_utility.set_window_start and I think this one set the window so that it can read the data from earliest SCN. I tried this but no luck. Unfortunately, I could not find any documentation on this package. 4. Documentation says that old data in the change table get purged automatically as long as there are no active subscriptions. Looks like it is not happening and I also tried manually using the DBMS_CDC_PUBLISH.PURGE and the old data did not get purged. 5. Change table captures only the changed records. Is there anyway I can see all the source table records in the change table initially. It helps for the initial load to go after the change table rather than the source table. Database : 9.2.0.1 OS : Solaris Thanks for your help. Best Regards, Prasad 860 843 8377 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
