Database Replication

Pradeep_Tiwari used Ask the Experts™

I have a scenario like, am having two databases DB1 and DB2 in different locations where I need to replicate some of the tables(around 10 to 15 tables) from DB1 to DB2(i.e. Whenever I
update any table in DB1 it has to reflect in DB2.). Both DB1 and DB2 has the same database objects.
(DB version - Oracle 10g Release

Please suggest me the steps how this can be done. Can it be done using Materialised View or else guide me for some optimal solution.


Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

You use snapshot (materialsed view) for tis issue. Other wise you need to buy som tools to read and write from redo log file. (but for just 15 tables is not a goog idea).
you need to create snapshot log in DB1 for each table
Create snapshot log on table "youtable"
then go to database DB2 and create snapshot like thet
create snapshot view "your_name" referesh force start with to_date('02-02-2010 12:00:00' ,'dd-mm-yyyy hh24:mi:ss') next "choose your next time" as select * from "your_table"@"yuor link"
Remember your snapshot log is short if you refresh more (depend on activity on this table). And first time you do is take a long time to create snapshot and log. After that is depend on snapshot log.

Shaju KumbalathDeputy General Manager - IT

refer the below mentioned  link 
Most Valuable Expert 2012
Distinguished Expert 2018
Pradeep_Tiwari ,

I believe this has been covered in your other question.

I will again suggest Oracle Streams.

Please refer to my comments in the other question:


isuue solved

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial