|
|
|
|
|
|
|
|
|
|
|
|
| Re: Objects refering to db links [message #517533 is a reply to message #516966] |
Tue, 26 July 2011 08:25  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
