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 -> Re: sqlnet2.1 & local instance connections

Re: sqlnet2.1 & local instance connections

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1997/07/22
Message-ID: <33D5849F.42B4@cadvision.com>#1/1

Duncan Reed wrote:
I would set up my internal db_links, hardcoded, so that they point to the proper live database from the test one.

 machine 1                   machine 2

 instance test, SID TEST1 instance test, SID TEST2  instance live, SID LIVE1 instance live, SID LIVE2

TEST1 would have a DB_LINK named LIVE using 'LIVE1' TEST2 would have a DB_LINK named LIVE using 'LIVE2'

in your SQL on either TEST1 or TEST2, refering to '..._at_LIVE' would put you on the right machine, and the right instance.

Wayne Linton Received on Tue Jul 22 1997 - 00:00:00 CDT

Original text of this message

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