| Synchronising two tables [message #366458] |
Thu, 04 February 1999 14:54  |
Amit
Messages: 166
Registered: February 1999
|
Senior Member |
|
|
Is there a way to synchronize two production (with parallel transaction) tables "with same names" on two diffrent databases which reside on diffrent Oracle instances on diffrent mchines.
So that any transaction in table1 is recorded in table2 and vice versa "Asynchronously" we dont want to use triggers and two face commits because
1.transactons are not that important but the tables must be synchronised at least once an hour.
2.We dont want to loose any transaction asynchronous tables might be accptable for sometime (which might be the case with two face commits)
The sanpshots tend to create a table with diffrent name in the child database (called SNAP$_snapshot_name)Is there any way to avoid this.
Amit
|
|
|
|
| Re: Synchronising two tables [message #366460 is a reply to message #366458] |
Mon, 29 March 1999 19:06  |
Mark Pass
Messages: 1
Registered: March 1999
|
Junior Member |
|
|
ITA's "Mobile/DB" Synchronization product will perform this. This product is extremely flexible and you can run it in a periodic batch mode ("hourly" as you mentioned).
The majority of the ITA customer list consists of companies that attempted to use Oracle's replication to meet their distributed data dilemma or their mobile computing challenge.
|
|
|
|
| Re: Synchronising two tables [message #366463 is a reply to message #366458] |
Tue, 04 May 1999 16:34 |
Rajeeva
Messages: 20
Registered: October 1998
|
Junior Member |
|
|
|
The ideal thing is to user Oracle replication on async mode. You can schedule a job to run every hour or so. This will not have any impact on the first database and the data will be quite safe.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
