
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
hello, 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
| <-- __Chronological__ --> | <-- __Thread__ --> |