This article explains steps for removing the tables/schema from live replication.
You can remove a table or schema from live replication by executing the
unprepare command in the replication console.
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