Re: Loading data continually

Pete_Thomas_at_inmarsat.org schrieb:
>
> 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.

Hallo Pete
pleas give some more information.

What version of Oracle do you use?
What is the size of your records?
How long do you want to store this records? Do you want to store it in one large table or do you want to store it in diffreent tables.

Jens Loebling Received on Thu Jul 01 1999 - 12:36:11 CDT