Re: Inserting Across Oracle Databases With Common Name

From: John Koo <johnkoo_at_i-wave.net>
Date: Mon, 08 Feb 1999 17:05:18 +0000
Message-ID: <36BF194E.88742A11@i-wave.net>

Michael Murphy wrote:

> Hi -
> Could someone educate me on the following:
> How does one post data from one Oracle database to another Oracle
> database on a different computer but with the same database name as
> production. Can we specify a platform / I.P. name in the SQL?
>
> We are looking to post off production tables to a test configuration
> using Oracle database capabilities. Production is v7.3 and test is 7.2,
> both on AIX.
>
> Thanks for assistance.
>
> Mike Murphy
> murphym_at_ajillus.com

Did the parameter "GLOBAL_NAMES" in your databases init.ora set to TRUE ?? Should they be set to other thing else in order to build a proper database link ??

John K. Received on Mon Feb 08 1999 - 11:05:18 CST