Re: Loading data continually

Why don't you use replication?
(Replication Option)

Mark

<Pete_Thomas_at_inmarsat.org> wrote in message news:7lfon0$cn7$1_at_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 - 13:00:32 CDT