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.
- 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.
- 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?
- 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.
- 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.
- 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: Prasada.Gunda_at_hartfordlife.com
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: ListGuru_at_fatcity.com (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).
Received on Mon Aug 18 2003 - 22:29:28 CDT
