Home » RDBMS Server » Networking and Gateways » Objects refering to db links (Oracle, 11.1.0.7.0.7, Unix-HP)
Objects refering to db links [message #516960] Thu, 21 July 2011 08:55 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

Can somebody tell me how to find out what are all the objects referring to particular database links in database?

Thank

[Updated on: Thu, 21 July 2011 08:57]

Report message to a moderator

Re: Objects refering to db links [message #516962 is a reply to message #516960] Thu, 21 July 2011 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can somebody tell me how to find out what are all the objects referring to particular database links in database?
Objects could be external to the DB which we don't know & can't control.
Re: Objects refering to db links [message #516963 is a reply to message #516960] Thu, 21 July 2011 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_dependencies

Regards
Michel
Re: Objects refering to db links [message #516966 is a reply to message #516963] Thu, 21 July 2011 09:12 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Let me be clear with my question.

There is one db link that consist of 50 objects in database A.The other database B has
same database link and has just 25 objects referring to the link.

Now i want to move all those (25) objects left out in B database.

Pls advice.

Thanks
Re: Objects refering to db links [message #516970 is a reply to message #516966] Thu, 21 July 2011 09:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>There is one db link that consist of 50 objects in database A.
post SQL & results that show above is true.

>The other database B has same database link and has just 25 objects referring to the link.
post SQL & results that show above is true.

You would benefit from Reading The Fine Manual

http://download.oracle.com/docs/cd/E11882_01/server.112/e16508/toc.htm

[Updated on: Thu, 21 July 2011 10:11]

Report message to a moderator

Re: Objects refering to db links [message #516988 is a reply to message #516966] Thu, 21 July 2011 11:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
There is one db link that consist of 50 objects in database A.

This a non-sense.

Quote:
Pls advice.

Please FIRST answer the questions I asked on the many other topics you didn't answer.
Please FIRST feedback on the many other topics you didn't feedback.
Please do NOT use IM speak.
Please explain in details your issue.
Please read the documentation.
Please do NOT fake your questions and outputs.

Regards
Michel
Re: Objects refering to db links [message #517533 is a reply to message #516966] Tue, 26 July 2011 08:25 Go to previous message
tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV
Member
You are not giving a clear description of the problem nor are you really providing enough detail.

You state that there is one db link that consist of 50 objects in database A.

What do you mean by that? Do you mean that there are 50 objects within database A that refer to this DB link? Or do you mean that when you use the DB link you can access 40 objects?

Show the sql that you are executing to get your 50 object count so that we might understand you better.

One of two things are happening here...

1. Your database link is named the same thing within both databases, however the connection information is different.

a) So you have a database named mydblink in both databases but in database A it connects using USERNAMEa and database B it connects using USERNAMEb. Those users have access to different objects within the database C.

b) Perhaps the same user but connecting to different databases.
The DB Link in A connects to B and the DB Link in B connects to A. Database B has a lot more objects in it for the user than Database A so perhaps that is what you are seeing.

2. Your databases are suppose to be duplicates but some objects are missing. So do a schema comparison between the databases and see what objects are missing.

.....Provide more information such as

select * from dba_db_links;

The SQL you used to get the object counts you refered to.

A select statement using all_dependencies to show the differences between the databases.

Return here and tell us what you find or if you solve the problem....you been doing this for years...provide some type of feedback.

Regards
Tim
Previous Topic: C++ and error ORA-12154
Next Topic: Multiple home listener configuration
Goto Forum:
  


Current Time: Thu Mar 28 13:49:38 CDT 2024