Re: Multiple Databases

Hi Steven,

You can just select the data over a database link from prod1 to prod2. To do this You have to make either prod1 visible to prod2 or prod2 visible for prod1. I would prefer to make prod1 visible to prod2 and make an INSERT AS SELECT into a table of prod2. Visible here means that prod2 must ahve an entry in the tnsnames.ora file of the prod1 database.
For the database link You should look into the SQL Reference from Oracle.

--
Best Regards,

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third party organizations.

Steven R Fuller wrote:

> Please Help!!!, What is the best way to pull data from one dataabse to
> another.
>
> I want to extract data from database 1, called prod1
> manipulate the data
> and load it onto database 2, called prod2
>
> Is this depenendent upon the tnsnames.ora file? At this point I have to
> disconnect
> from prod1 and reconnect to prod2
Received on Sun Aug 29 1999 - 06:46:30 CDT