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

Home -> Community -> Usenet -> c.d.o.server -> Communication between 2 databases

Communication between 2 databases

From: <sanshah_at_my-dejanews.com>
Date: Wed, 17 Mar 1999 21:33:45 GMT
Message-ID: <7cp73o$50o$1@nnrp1.dejanews.com>


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 Received on Wed Mar 17 1999 - 15:33:45 CST

Original text of this message

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