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 etc.ie; 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
