Seedyman wrote:I appears that if the subscriber does the above for all tables it works as expected but if the /extend window/prepare view/select/drop view/purge window/ process is only done for one table no amount of calling the DBMS_LOGMNR_CDC_PUBLISH.PURGE procedure will remove any rows from the capture table. But as soon as all of the subscribed tables are processed, the DBMS_LOGMNR_CDC_PUBLISH.PURGE procedure purges all of the appropriate rows from all of the capture tables.
Does anyone know of anyplace I can get more detailed information on how the CDC process works in 9i?
I had no trouble with 1 capture table, but as soon as I added a second I noticed that even after I did a manual purge the entries in the capture table were not going away until much later.
Oracle version is 22.214.171.124.0
after creating capture table and subscribing
I am following the process of
as subscriber: (for each table)
select from CDCview
as publisher: (after all tables processed)
It seems to eventually purge the capture tables, but I recently added a rather high traffic table to the list and would like it to purge more often than it seems to do by default.
There is only one publisher and one subscriber