Remove a Table or Schema from Live Replication

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

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>

Example

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