Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to connect 2 databases on 2 different servers and retrieve information

Re: How to connect 2 databases on 2 different servers and retrieve information

From: Herod <herodt_at_gmail.com>
Date: 6 Mar 2006 11:02:10 -0800
Message-ID: <1141671730.257371.327080@i40g2000cwc.googlegroups.com>


Once the link is created the password is stored in the database.

For large tables, I use a materialized view (snapshot) on the table(s) on the other database to keep the data syncronized.

Then query the materialized view locally and I let oracle keep the view up to date. Received on Mon Mar 06 2006 - 13:02:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US