Re: RE : ok for the last 18 yrs in using oracle I must have been asleep, "implied database link"
Date: Thu, 18 Feb 2010 17:47:34 -0800 (PST)
Message-ID: <251323.60026.qm_at_web32008.mail.mud.yahoo.com>
I tested it, finding it impossible to believe and was shocked to discover it works, just as described, in 10.2.0.4...
SQL> connect system_at_marta
Enter password: ***************
Connected.
SQL> select count(*) from dba_tables_at_martc
2 where owner='DM_OWNER';
COUNT(*)
275
"Kellyn feels sick...and proceeds to update and ensure that all her system passwords are different for each database...."
Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen www.dbakevlar.blogspot.com
"Go away before I replace you with a very small and efficient shell script..."
- On Thu, 2/18/10, Bertrand Guillaumin <bertrand.guillaumin_at_digora.com> wrote:
From: Bertrand Guillaumin <bertrand.guillaumin_at_digora.com> Subject: RE : ok for the last 18 yrs in using oracle I must have been asleep, "implied database link" To: "robertgfreeman_at_yahoo.com" <robertgfreeman_at_yahoo.com>, "TESTAJ3_at_nationwide.com" <TESTAJ3_at_nationwide.com>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Date: Thursday, February 18, 2010, 7:20 AM
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 18 2010 - 19:47:34 CST