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

Home -> Community -> Usenet -> c.d.o.tools -> Re: one connexion for two database ORACLE

Re: one connexion for two database ORACLE

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Mon, 18 Jun 2001 13:30:41 -0700
Message-ID: <3B2E64F1.87EB3AD3@attws.com> 






Frederic GERNEZ wrote:



> hello,

>

>     I have two database (2 datamart dm1 & dm2) and i would like ,with one

> SQLPLUS connexion, to see the tables from dm1 and dm2.

>

> thanks.




Build a database link between the two instances.



Log onto the one hosting the link and reference the tables in the other.



Daniel A. Morgan
Received on Mon Jun 18 2001 - 15:30:41 CDT












Original text of this message













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