Re: Dblink in Oracle10g

From: Yechiel Adar <>
Date: Tue, 18 Nov 2008 17:48:13 +0200
Message-id: <>

select username , a.*
from$ a , all_users
where a.owner# = user_id;
I think that will give you all the fields you need to create the DDL for the creation of the dblinks.
You need of course to connect as sys or to grant your user select an$.

I suggest you use this opportunity to remove all user name and password from the dblinks.
We have dblinks that contains user name and passwords and I remove them whenever I can.

Adar Yechiel
Rechovot, Israel

Nagaraj S wrote:
> Hi Gurus,
> I have a requirement. I need to drop all the DB links in the
> Development database and recreate them as of Production database. How
> can i do that...
> Am aware on oracle 9i we can use dynamic script to create dblink by
> querying$. How can I over come this in 10g
> Regards,
> Nagaraj

Received on Tue Nov 18 2008 - 09:48:13 CST

Original text of this message