-- get deletes for these tables
--- exclude tables for which we get deletes
--- push rest with no deletes
I want to capture deletes for all tables but scott.gg_test. However, this does not happen. All DML for the table gg_test is ignored ! Pushing the first 2 lines to be after the 'TABLE scott.*' causes duplicates on inserts.
Any ideas on how I can use the wildcard with a TABLEEXCLUDE and and then include the excluded table with diff DML capture options ?