Re: Copy from DB to DB within PL/SQL?

Do you have a database link between them? If so, you can use use a single PL/SQL procedure running on your 8.1.5 instance to SELECT from tableA_at_instance1 (the 7.3.4) and insert into tableB (on the 8.1.5 instance).

John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL

Stephen Pennine <spennine_at_home.com> wrote in message news:bc697ts3df34inchb829cl3bjf2g0upn9n_at_4ax.com...
> Greetings group members, here's a new query.
>
> We have 2 Oracle DB's in production, 1 at 734, and another at 815. I
> know both should be at 815, but have no control over that situation.
> I'm just a techie... and I've told them this before.
>
> We'd like to write a PL/SQL procedure be able to copy from the 734 DB
> to the 815 DB.
> The procedure will run on the 815 machine; it would connect to the
> 734, get the data it needed, and bring it back to the 815.
> (Running on the 734 is an option, but our area owns the 815, and it's
> really our project, so we don't want to be writing code in someone
> elses application area)
> The procedure will be run nightly under the control of the Oracle job
> queue, via the DBMS_JOB package.
>
> We know of the SQL*Plus COPY <FROM/TO> command, but this is specific
> to SQL*Plus, and as such, won't run under PL/SQL.
> We also know that we could EXPORT the data from the 734 machine, and
> the 815 machine could IMPORT it. However, compatibility issues aside,
> these boxes are in different business areas, and requesting resources
> from that area would slow our initiative in addition to the fact that
> IMPORT/EXPORT is woefully inefficient.
>
> Is there a way within 815 PL/SQL to connect to other DB's and move
> data between? Our project needs this functionality to be automated
> and efficient. We have lots of data, and average equipment.
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
>
Received on Sun Jan 28 2001 - 18:06:24 CST