We're here to help!

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

Follow
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

Have more questions? Submit a request

Comments