Re: Loading Data
Date: Tue, 28 Nov 2000 15:46:39 -0500
Message-ID: <hRUU5.73222$Z2.988728_at_nnrp1.uunet.ca>
Hi David!
I think you can use some approaches to do this.
For example - to create a database link between two servers
(a lot of details on how to do this you can find in Distributed Database
Systems
manual) or write a SQL*Plus script that will upload data on one
server, then copy them to another server and load them by using
SQL*Loader (and it can be organized via cron), etc.
Andrew Velichko
Brainbench MVP for Oracle Developer 2000
http://www.brainbench.com
"D.D." <d.delisser_at_worldnet.att.net> wrote in message
news:HiEU5.144$2P3.13126_at_bgtnsc06-news.ops.worldnet.att.net...
> Help!
>
> I need to retrieve data from another sever each night. The data will go
> into an existing table on the current server. Example, tables are set up
on
> one server, I want to be able to create the table and load the data from
> another server each night. I have no idea how to do this or what tools to
> use to accomplish this. Please help!
>
> Thanks for your help!
> David
>
>
Received on Tue Nov 28 2000 - 21:46:39 CET