Re: copy data from remote database with near real-time

From: Sybrand Bakker <postbus_at_sybrandb.demon-verwijderdit.nl>
Date: Thu, 29 Aug 2002 22:38:43 +0200
Message-ID: <1i1tmuc0ala7vd4hmlu62l7p3p8i5vueve@4ax.com>

On 29 Aug 2002 12:51:49 -0700, zj411_at_yahoo.com (john) wrote:

>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.

sure, upgrade 7.1.5 to something supported

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Aug 29 2002 - 15:38:43 CDT