Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to connect 2 databases on 2 different servers and retrieve information
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