| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Communication between 2 databases
sanshah_at_my-dejanews.com wrote:
>
> I have two different databases A and B residing on the same server. There is a
> procedure in database A that references a table present on database B.
>
> 1. How should my procedure be modified so that the procedure can identify the
> table present on the other database.
>
> 2. Do I modify anything in the configuration settings (tnsnames, etc ) to
> allow the two databases to talk to each other
>
> 3. Also if in the future the 2 databases were to reside on 2 different servers
> what needs to be done to achieve the above stated results.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
You need a database link:
create database link xxx
connect to abc
identified by def
using 'xyz';
But there is a fair bit more to this...
Check the "Distributed Systems Vol 1" in the Oracle doco
Cheers
--
 |
 |