Re: Posting To Oracle Databases On Different Platforms But Same Names

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Sat, 06 Feb 1999 00:23:19 +0000
Message-ID: <36BB8B77.53469290@rdbms.freeserve.co.uk>

Michael,

Look at setting up a DBLINK between the two databases.

Chris

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
Received on Fri Feb 05 1999 - 18:23:19 CST