Remove a Table or Schema from Live Replication

Problem Description

This article explains steps for removing the tables/schema from live replication.

Description

You can remove a table or schema from live replication by executing the unprepare command in the replication console.

Syntax

UNPREPARE SCHEMA <SCHEMA>
UNPREPARE TABLE <SCHEMA.TABLE>

dbvrep> UNPREPARE SCHEMA SCOTT
dbvrep> UNPREPARE TABLE SCOTT.EMP

Note: The above command is used to remove tables or schemas from the replication and declares that this object should no longer be replicated.

Krupesh Desai October 09, 2014 09:52