Home » RDBMS Server » Networking and Gateways » How to find all the objects referring to DB Link (Oracle 10g, SunOS)
How to find all the objects referring to DB Link [message #563268] Fri, 10 August 2012 12:04 Go to next message
kamal1026
Messages: 1
Registered: July 2012
Junior Member
Hi,

We have two schemas which earlier used to be separate databases. There were DB links created to access the objects from one schema to the other schema when they were separate databases.

Since now they are just 2 separate schema with in the same Database, we would like to remove the DB Links and create synonyms to access those objects. These DB links were used in code in many places, it is becoming tough to find a way to implement this.

Can any one give me an idea how to find all the objects that are using these objects or all the places these DB likns were being used.

Thanks in Advance,
Kamal
Re: How to find all the objects referring to DB Link [message #563273 is a reply to message #563268] Fri, 10 August 2012 12:31 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try all/dba_dependencies.

Or the scrits at:
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1236
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1237

Regards
Michel
Previous Topic: Steps for Access remote Oracle Db [VB-Oracle-10G]
Next Topic: tns_admin
Goto Forum:
  


Current Time: Thu Mar 28 06:22:30 CDT 2024