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: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