Sounds like a business case to upgrade to oracle 11 and use the active data guard option :) Stefan ========================= Stefan P Knecht CEO & Founder s@xxxxxxxx 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 Wallisellen Switzerland Phone +41-(0)8400-10046 Cell +41 (0) 79 571 36 27 info@xxxxxxxx http://www.10046.ch ========================= On Fri, Aug 27, 2010 at 7:21 AM, 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 > > >