Re: Dblink in Oracle10g
Date: Tue, 18 Nov 2008 17:48:13 +0200
Message-id: <4922E3BD.5060700@inter.net.il>
select username , a.*
from sys.link$ 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
sys.link$.
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 sys.link$. How can I over come this in 10g
>
>
>
> Regards,
> Nagaraj
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 18 2008 - 09:48:13 CST