How to view Tables that are Excluded/Included if DDL Replication Is Enabled?

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
1 min read

Description

This Article explains how to view tables which have been excluded from replicate.

Solution

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