Re: RE : ok for the last 18 yrs in using oracle I must have been asleep, "implied database link"

I could not produce it either on 10.2.0.4

On 18 February 2010 14:20, Bertrand Guillaumin < bertrand.guillaumin_at_digora.com> wrote:

> Hi,
> Are you sure it exists ? I've made tests and it does not work at least in
> 10.2.0.3.
> sqlplus system/pass_at_db1
>
> SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 18 15:16:38 2010
>
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
> Production
> With the Partitioning, OLAP and Data Mining options
>
>
> SQL> SELECT * FROM DBA_USERS_at_db2;
> SELECT * FROM DBA_USERS_at_db2
> *
> ERROR at line 1:
> ORA-02019: connection description for remote database not found
>
> sqlplus system/pass_at_db2
>
>
> SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 18 15:16:38 2010
>
> Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
> Production
> With the Partitioning, OLAP and Data Mining options
>
>
> I've even verified in the documentation and I haven't found trace of it.
>
> Best regards,
>
> ________________________________________
> De : oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] de la
> part de Robert Freeman [robertgfreeman_at_yahoo.com]
> Date d'envoi : jeudi 18 février 2010 00:54
> À : TESTAJ3_at_nationwide.com; oracle-l_at_freelists.org
> Objet : Re: ok for the last 18 yrs in using oracle I must have been asleep,
> "implied database link"
>
> In my mind, if someone is doing such things in code, this is probably a bad
> practice. Also I'm not sure it's a great idea from a security point-of-view
> to allow such things. Anyone else have any thoughts here?
>
> RF
>
>
> Robert G. Freeman
> Master Principle Consultant, Oracle Corporation
> Oracle ACE
> Author:
> Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY
> SOON!
> OCP: Oracle Database 11g Administrator Certified Professional Study Guide
> (Sybex)
> Oracle Database 11g New Features (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Other various titles
> Blog: http://robertgfreeman.blogspot.com
>
>
> ________________________________
> From: "TESTAJ3_at_nationwide.com" <TESTAJ3_at_nationwide.com>
> To: oracle-l_at_freelists.org
> Sent: Wed, February 17, 2010 1:15:18 PM
> Subject: ok for the last 18 yrs in using oracle I must have been asleep,
> "implied database link"
>
>
> Ok so a co-worker asks a question about an implied database link, i'm like
> "huh".
>
> so a database link is NOT created in the source database but the
> userid/password are the same in both source and destination.
>
> take for example
>
> system on db1 and db2 has a password of x12345.
>
> I do a select count(*) from dba_users_at_db2 while connected on db1 and it
> connects and returns a result set w/o a db link being created.
>
> I've been enlightened again of something new about oracle.
>
> so the question posed is, for a named db link you do "close" it, how do you
> close an implied link?
>
> joe
> _______________________________________
> Joe Testa, Oracle Certified Professional
> Senior Engineering & Administration Lead
> (Work) 614-677-1668
> (Cell) 614-312-6715
>
> Interested in helping out your marriage?
> Ask me about "Weekend to Remember"
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Coskan GUNDOGAR

Oracle DBA

Email: gundogar_at_gmail.com
Blog: http://coskan.wordpress.com
Twitter: http://www.twitter.com/coskan
Linkedin: http://uk.linkedin.com/in/coskan

--
http://www.freelists.org/webpage/oracle-l