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
Messages: 1
Registered: July 2012
Junior Member

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,
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: 68310
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try all/dba_dependencies.

Or the scrits at:

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

Current Time: Sat Nov 26 23:31:54 CST 2022