copy data from remote database with near real-time

From: john <zj411_at_yahoo.com>
Date: 29 Aug 2002 12:51:49 -0700
Message-ID: <87f5a9b7.0208291151.4aeffdb7@posting.google.com>

I have 9i locally and need to copy data from remote database that is 7.1.5. Since 7.1.5 doesn't support replication, I am using scheduled job(interval=10 seconds) to call following statement.

insert into LOCALTABLE select * from REMOTETABLE_at_DBLINK where ...

Rows are inserted(no update and delete transaction) in remote table frequently. Average 2-5 rows added every second.

I'd like to synchronize both local and remote tables with near real-time. Is there any better solution?

Thanks. Received on Thu Aug 29 2002 - 14:51:49 CDT