How to omit a table from Streams schema-based replication
edited Nov 28, 2014 9:54AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered ✓
Hi,
My customer has Streams-based replication replicating data between the same schema on 2 databases (both 11.2.0.4). He wants to create a rule to prevent the capture process from capturing DML activity on any table whose name starts 'CMP3$', Unfortunately he does not know the names of these tables because they are created and dropped by maintenance processes.
How could I best create a rule to prevent the capture process from capturing DML for such tables? I have looked at the specifications for 'dbms_streams_adm.add_table_rules', and 'dbms_streams_adm.add_schema_rules', but I see no way of specifying a 'wild card' (i.e. 'CMP3$%').
1