| DB Link problem. [message #408771] |
Wed, 17 June 2009 14:02  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi All,
In production database,in a schema there is a synonym ""LOG" which is refering a table in another database
using database link "RTP.WORLD" and the package "ORD_PKG" which is using that synonym is valid.
Yesterday, I refreshed the development schema in development with production schema,
after refresh We drop the db link "RTP.WORLD" and create the db link "RTD.WORLD" and
recreate the corresponding the synonyms so that it points to "RTD.WORLD".
Everything is working fine upto this point but when I try to recompile the package "ORD_PKG"
it is hanging and then I checked using following query,
| Quote: | select referenced_link_name from user_dependencies where name='ORD_PKG'
this query returns "RTP.WORLD".
|
| Quote: | select db_link from user_synonyms where synonym_name='LOG'
this query return "RTD.WORLD".
|
I think the compilation problem because the package while using that synonym
it refers the db link "RTP.WORLD" which is not existing in the development database.
Because of this problem I couldn't compile "ORD_PKG" and it is invalid status.
Please anyone help me in resolving this problem so that I can compile the package body successfully.
Thanks..
|
|
|
|
|
|
| Re: DB Link problem. [message #408794 is a reply to message #408771] |
Wed, 17 June 2009 16:35  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi,
There is no problem with permission and the db link "RTD.WORLD" is working fine, the package compilation is hanging jsu because
the PKG refers the db link "RTD.WORLD" which is not existing in dev database.
Thanks..
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
