This Article explains how to view tables which have been excluded from replicate.
If you have DDL enabled, by default Replicate will try and send those from the source to the target. There may be times that you wish to exclude certain tables from replication. The command is
EXCLUDE CREATE TABLE scott.emp%. If you want to see what rules are currently set you can use the
show command. For example:
dbvrep> include create table show List of excluded (included) tables: EXCLUDE CREATE TABLE CLEAR EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_UNCMP EXCLUDE CREATE TABLE %.DBMS_TABCOMP_TEMP_CMP INCLUDE CREATE TABLE repoe.drama% 3 rule(s) listed.
Chris Lawless December 25, 2014 05:44