Loading data continually

From: <Pete_Thomas_at_inmarsat.org>
Date: Thu, 01 Jul 1999 12:59:18 GMT
Message-ID: <7lfon0$cn7$1@nnrp1.deja.com>

We are looking to load an Oracle DB using data from four remote machines that are in different countries, but would like to provide a continuous almost real time load.

Our DB Server is running NT.

Has anyone tried this type of thing ?
What are the options & pros & cons of the following options ?

FTPing files back to our DB server, then continually loading but I guess we would need some kind of staging area ?
Using some messaging type software ? Like OrbixTalk ?
Setting up the remote machines as clients using SQL*Net ?

In total we would be loading about 202,000 rows per hour or 3,380 per minute ?

Is this feasible, what sort of Server specification could cope ?

Also users would be querying data at the same time, but that data would normally be in a different partition.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 01 1999 - 07:59:18 CDT