Re: TOAD 11 - issue with "DB Links"

mr2001 <[email protected]> Wed, 05 Oct 2011 11:19:18 PDT

Newsgroups	gmane.comp.db.oracle.toad.free
Message-ID	<6638406.7311317838789031.JavaMail.SYSTEM@alvqcfw02>

 Message from: mr2001 

Sorry, I just realized that the &quot;DB Link&quot; I created&nbsp;above shows up in the PUBLIC schema...

Regards,
M.R.

_______________________________________

Historical Messages 


Author: mr2001
Date: Wed Oct 05 11:19:18 PDT 2011
Sorry, I just realized that the &quot;DB Link&quot; I created&nbsp;above shows up in the PUBLIC schema...

Regards,
M.R.
__

Author: mr2001
Date: Wed Oct 05 11:09:02 PDT 2011
Hello,

I created a DB Link using the following syntax:

 create   shared   public   database   link   &quot;rs_link&quot; authenticated   by  RBS_MASTER identified   by   &quot;pwdtest1&quot; USING   &#39;(DESCRIPTION=   (ADDRESS= (PROTOCOL=TCP) (HOST=ORACLE1) (PORT=1521) ) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=dev) ) )&#39;

 The&nbsp;link works fine, I can copy records from one database to another.
However, this link  does not show  in TOAD &quot;DB Links&quot; node... 

Please advise.

Regards,
M.R.
__
_______________________________________