This content has been marked as final. Show 1 reply
Yes , you can replicate full table level or column level data with help of Oracle GoldenGate , the below parameters will help you to achive your requirments,
1. Use COLS and COLSEXCEPT to control column selection.
2. Use COLS to specify columns whose data you want to synchronize. All other columns are ignored by Oracle GoldenGate.
3. Use COLSEXCEPT to exclude columns from synchronization. All other columns are processed by Oracle GoldenGate. For tables with numerous columns, COLSEXCEPT may be more efficient than listing each column with COLS.
Hopefully this will help you