Adding Tables Using the Silent Flag

Problem Description

This article explains how to Add/Prepare tables to replication using the silent Flag. This suppresses the header messages which might be unwanted when executed by a script or batch process.

Solution

Adding tables into an existing Replication can be performed using the

-silent

flag to suppress the display of header information. For example:

On the Source Machine where Replicate console is running, navigate to the DDC directory:
$cd /home/oracle/REPPOC
Add table test.t2 using:
$./start-console.sh --silent prepare table test.t2

When replicating multiple tables you can simplify the process by creating a bash script. For example test.sh:

#!/bin/bash
cd /home/oracle/REPPOC
./start-console.sh --silent prepare table test.t2
./start-console.sh --silent prepare table test.t3
./start-console.sh --silent prepare table test.t4

Executing test.sh outputs the following:

Other ways to add tables to a Replication include:

The LOAD command which is only used when adding tables through the setup wizard. For details see:
https://dbvisit.atlassian.net/wiki/display/ugd7/Load
The PREPARE TABLE command from the Dbvisit Console. For details see:
https://dbvisit.atlassian.net/wiki/display/ugd7/One+Way+Replication

Ankit Arora January 23, 2015 14:09