OraFAQ Forum: Networking and Gateways » How to find all the objects referring to DB Link

Home » RDBMS Server » Networking and Gateways » How to find all the objects referring to DB Link (Oracle 10g, SunOS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find all the objects referring to DB Link [message #563268]

Fri, 10 August 2012 12:04

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

Report message to a moderator