This content has been marked as final. Show 3 replies
Using which tool or technology? Streams, GoldenGate, some third party product?
It's relatively simple to do in Streams and GoldenGate.
With GoldenGate, the TABLE parameter in the extract could used COLS (to grab the columns you want) or COLSEXCEPT (to exclude the columns you do not want). And if for certain rows, you can filter (to get those) using a WHERE clause.
Oracle Streams info (plus see database docuementation)
Pro: you've already paid for it
Con: relatively complex to setup/use/monitor, probably not much in the way of future enhancements
Pro: like Apple, it just works
Con: hugely expensive, but is the strategic direction for replication and data integration