Re: Dblink in Oracle10g
Date: Tue, 18 Nov 2008 17:48:13 +0200
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.
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