Re: Real time data trasfer between 2 DB
Date: Fri, 27 Aug 2010 07:43:25 +0200
Sounds like a business case to upgrade to oracle 11 and use the active data guard option :)
Stefan P Knecht
CEO & Founder
10046 Consulting GmbH
Cell +41 (0) 79 571 36 27
On Fri, Aug 27, 2010 at 7:21 AM, Arvind Kumar (IT-SIS-UIF) < Arvind.Kumar_at_labour.gov.za> 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.
> Arvind Kumar