Adding Tables Using the Silent Flag
- Clive Otten (Unlicensed)
Analytics
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/REPPOCAdd table
test.t2using:$./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.t4Executing test.sh outputs the following:
Other ways to add tables to a Replication include:
The
LOADcommand which is only used when adding tables through the setup wizard. For details see:The
PREPARE TABLEcommand from the Dbvisit Console. For details see:https://dbvisit.atlassian.net/wiki/display/ugd7/One+Way+Replication
Ankit Arora January 23, 2015 14:09