This content has been marked as final. Show 2 replies
Streams can do this, so can GoldenGate. Both are "checkpoint aware" in the sense that they know where to start from upon startup. Streams is free, already paid for in licensing for the RDBMS; GoldenGate is an extra cost item/application.
If using Streams, you do have some limitations in terms of performance. If you are using Enterprise Edition, you're good to go, but if using Standard Edition, Streams doesn't perform as well and it is better suited for smaller amounts of data/fewer tables.