Fw: Re: ok for the last 18 yrs in using oracle I must have been asle

• On Thu, 2/18/10, Yong Huang <yong321_at_yahoo.com> wrote:

> To: TESTAJ3_at_nationwide.com
> Date: Thursday, February 18, 2010, 9:59 AM
>
> 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.

Are you using OID or tnsManager? If so, we've discussed it before:

http://www.freelists.org/post/oracle-l/Use-of-OID-for-name-resolution,3

and the next message from Mark.

To explicitly close the DB link, just:

rollback; (or commit;)
alter session close database link thelinkname;

Yong Huang       

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