...
The steps are as follows:
Edit the *.dbvrep file and after the last line in the dbvrep file, add:
| No Format |
|---|
EXCLUDE COLUMN OFFLINE SCHEMA.TABLE.COLUMN_NAME |
...
| No Format | ||
|---|---|---|
| ||
#prepare the tables (we use OFFLINE as neither MINE not APPLY is running; with OFFLINE we won't wait on network timeout) PREPARE OFFLINE SCHEMA OE NODDL ... ... EXCLUDE COLUMN OFFLINE OE.PRODUCT_DESCRIPTIONS.TRANSLATED_NAME EXCLUDE COLUMN OFFLINE OE.PRODUCT_DESCRIPTIONS.XML_DATA |
In this example the columns TRANSLATED_NAME and XML_DATA from the table PRODUCT_DESCRIPTIONS from schema OE are excluded in the replication.
...