Is the 5 second latency the time between broadcast of the data and the time it must be available in the second database? If you have a little more time in there, then I like the idea of queueing it into a flat file and loading it into both DB's from there. If it must go from the gps to db1 to db2, I would use triggers rather than streams or dataguard. Frankly, I think you will have more problems getting the data to the first database quickly then you will have replicating it over to the second. On Fri, Aug 27, 2010 at 7:17 AM, Subodh Deshpande < deshpande.subodh@xxxxxxxxx> wrote: > Hi Arvind, > > 0)worked on replication but now on bus transport system have not worked on > such system and hence random gueses > what if you pull the data from city buses, replication, streams, golden > gate will be more suitable, you want transactions only.. > pulling will keep the bus conductor/machine free from loading the data and > main hub will always know what is the status alogn with co-ordinates of city > bus > 1) insted installing databases in buses can the ticketing machine send the > data in flat file formats and that data you can be sent from wap devices to > a stage area from where you can load the data either using external > tables..or sqlloaders this will reduce the licensing cost.per city bus > ddatabse and maintence cost will be more.. > Thanks! > Subodh > On 27 August 2010 10:51, Arvind Kumar (IT-SIS-UIF) < > Arvind.Kumar@xxxxxxxxxxxxx> wrote: > >> Greeting all, >> >> >> >> What would be the best method to transfer data between two databases (10g >> R2) in real time (near real time). It’s a transport system where GPS devices >> installed in City Buses inserts records (location, timings) into oracle DB >> then this data has to be transferred to other oracle DB for reporting with a >> max latency on 5 second. >> >> Any input or experience on similar scenario will be highly appreciated. >> >> >> >> Thanks >> >> Arvind Kumar >> >> >> > > > > -- > ============================== > DO NOT FORGET TO SMILE TODAY > ============================== > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'