More Help Required.. in Replication of Oracle 9i in Rh9 (if the query is repeated by me sorry)

From: Cherrish Vaidiyan <>
Date: 2 Dec 2003 20:47:14 -0800
Message-ID: <>


Thanx for replying to my earlier Google group query about Replication of Oracle 9i on RH9.IF the query followed is being repeated by me I am sorry for it..

I want to implement replication by means of SQL commamnd prompt.Can u help me with the sample script that you own.I can change the schema, tables according to my need...Here is my situation of replication requirement...

I have 3 systems with RH 9. A database of Oracle 9i is to be replicated in the 3 pc.
I thought of Synchronous replication first where a change made once in a database is updated immediately in all the rest. but the drawback is that if 1 database server is down the update wont work ie it will rollback.but it wont have any conflicst if all servers are up.

But, I dont want rollback situation. So I want to implement Asynchronous replication which means that a change made will be stored initally as deferred transaction (I think v can set time for updates say for 2 seconds; every 2 sec cache and database will be updated...but i dont know the paramaeter to set)and later updated in all database.I know in such case I know in that case i have to handle conflicts (that the second phase). but wont check if all the database servers are up.

Hope u have understood my need and would help me ...pls reply regards,
Cherrish Vaidiyan
Received on Wed Dec 03 2003 - 05:47:14 CET

Original text of this message