This content has been marked as final. Show 2 replies
Oracle has other tools to do that, 1. Oracle Streams, 2. ODI, 3. Oracle Golden Gate....
If u r ready to invest pls go with it ,,,,
my best choice would be golden gate, bcos u can do transformations to different databases like ?(Oracle --> Sybase, DB2, Teradata etccccc.....)
or the other way is u can use RMAN, to backup and restore only the CDC.
Will these methods (Golden Gate, RMAN, Streams etc) work for Warehouse environment as well? For non-transactional database where tables are not changed and are used for reporting only?
Edited by: Arbind on Aug 24, 2011 9:37 AM