
	Home > Ask the Oracle Experts > SOA and Integration Questions & Answers > How to perform Oracle replication

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

How to perform Oracle replication

EXPERT RESPONSE FROM: Harish Harbham

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 11 June 2007
I am new to Oracle. I want to do Oracle replication. Can anyone help me by telling the steps of Oracle replication? Thanks in advance.

EXPERT RESPONSE
In Oracle there are three or four ways to carry out data replication. This subject is very large and I suggest you have a look at the following topics:

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.

You can find information on these methods here.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SOA and Integration
	How to transfer data from Oracle to MS SQL Server
	How to convert a SQL Server 2005 database to Oracle 10g
	Using Oracle Streams
	How to use Oracle Heterogeneous Services
	How to create a mediated schema
	Oracle Transparent Gateway for Unix
	How to dump SQL Server database with Oracle data
	Setting up backups with data replication
	Oracle or SQL Server for developing social networking site?
	Oracle 10g or SQL Server 2005?

Oracle data and application integration

Podcast: Oracle outlines AIA vision

Oracle's 10 steps to get to Fusion rely on Oracle investments

Oracle Fusion Middleware: Top five headlines

Oracle adds Data Integration Suite to middleware family

Oracle-BEA deal means tough choices for middleware buyers

Oracle to buy BEA Systems

Oracle adds Enterprise 2.0 to Fusion Middleware 11g

Oracle scoffs at BEA's buyout proposal

Oracle's Application Integration Architecture: An Oracle OpenWorld 2007 preview

Oracle bids for BEA Systems

Oracle database backup and recovery

Oracle 11g: Backup and recovery concepts

Weighing remote database administration pros and cons takes care

Data retention policy for Oracle DBAs: When to "trash" your data

Case study: Oracle RMAN improves backup and recovery efficiency in a multi-platform, multi-application environment

How do I do that in Oracle?

Oracle and the rise of the virtual machine

Oracle 11g data compression

Oracle OpenWorld 2007 Special Report

Hierarchical storage management for database growth, part 1

One datafile not accessible

Oracle database backup and recovery Research

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy