- Materialized views (snapshots). This is probably the simplest way to get started and is very easy to set up.
- Advanced replication. This is slowly being phased out in favor of Streams and requires quite a high level of Oracle knowledge.
- Oracle Streams.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Harish Harbham
SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server. Continue Reading
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication. Continue Reading
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?" Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.