
	Home > Ask the Oracle Database / Applications Experts > Oracle database design and architecture Questions & Answers > Partial database replication setup

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Partial database replication setup

EXPERT RESPONSE FROM: Brian Peasland

		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: 18 July 2006
I am interested in setting up a partial replication from one database to another. I have never done this before and would like some assistance in setting this up. Thanks.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Oracle database design and architecture
	Can I download DBCA for Oracle Express Edition?
	How to recreate an Oracle index in a new schema with the CREATE command
	Using Oracle Universal Installer to install Oracle with Pro*C
	Defining Oracle database repository vs. information repository
	Can I create multiple schemas in Oracle for one user?
	ORA-12514 error when connecting to the Oracle database through Toad
	Solving the ORA-00904 error: invalid identifier in Oracle
	How to tune SQL UPDATE statements for an Oracle 10g upgrade
	Will queries run slower in a smaller Oracle buffer cache?
	Using a database link to connect two Oracle apps instances

Oracle database design and architecture

Can I download DBCA for Oracle Express Edition?

How to recreate an Oracle index in a new schema with the CREATE command

Using Oracle Universal Installer to install Oracle with Pro*C

Defining Oracle database repository vs. information repository

Can I create multiple schemas in Oracle for one user?

ORA-12514 error when connecting to the Oracle database through Toad

Solving the ORA-00904 error: invalid identifier in Oracle

How to tune SQL UPDATE statements for an Oracle 10g upgrade

Will queries run slower in a smaller Oracle buffer cache?

Using a database link to connect two Oracle apps instances

Oracle database replication guide

Setting up backups with data replication

Merging records in Access and Oracle

Cloning database with hot backup

Setting up multi-master replication in Oracle 10g

Creating report from snapshots

Steps for database replication

Replication using LogMiner

Cloning a production database into a development server

Working with materialized views

Create a database clone using an open backup

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

E. F. Codd (SearchOracle.com)

extent (SearchOracle.com)

flexfield (SearchOracle.com)

foreign key (SearchOracle.com)

multidimensional database (SearchOracle.com)

object-oriented database management system (SearchOracle.com)

quad tree (SearchOracle.com)

relational online analytical processing (SearchOracle.com)

row (SearchOracle.com)

splay tree (SearchOracle.com)

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

Oracle has a product called Replication Services which performs this type of replication. This product costs additional funds which may not be justifiable for replicating a small subset of your database. If that is the case, then you can write your own replication routines using database triggers and database links.

Create the database link to the remote database:

CREATE DATABASE LINK link_name CONNECT TO 
username IDENTIFIED BY password USING 'tns_alias';

Create a trigger on the table which populates newly inserted rows into the remote database table.

CREATE TRIGGER my_table_insert_trig
BEFORE INSERT ON my_table
BEGIN
   INSERT INTO my_table@link_name VALUES 
   (:new.colA, :new.colB, ..., :new.colX);
END;
/

You'll have to create your own triggers similar to the above which perform your replication for you.

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

Oracle White Papers: Fusion Middleware

SEARCH

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


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