Re: Dblink in Oracle10g
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- To: nagaraj.chk@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- 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.
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:
