Re: Dblink in Oracle10g

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

Other related posts: