Hi Maria,
This error comes when the base object on which the synonym is based is
invalid / re-created. Follow these steps -
1. Check if the base object exists. If it doesn't then create the base
object and give grants to the synonym. If the base object exists, then
move to step 2.
2. Check if the base object is invalid. If its invalid, the recompile it
and then check if the synonym works.
3. If Synonym still doesn't work, then you will need to check whether
the necessary grants are given to the synonym.
I hope this helps.
Warm regards,
Vikas Bhat
Senior Software Engineer,
FBSI Pvt Ltd.,
Embassy Golf Links Business Park,
Intermediate Ring Road,
Bangalore - 560071
Email - vikas.[Email address protected]
Ph:91-80-56916482
Mob:91-9845589149
Those who aspire for the light of sun; need to bear its heat.
Any comments or statements made in this email are not necessarily those
of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity
Investments group companies. The information transmitted is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. If you have received this in
error, please contact the sender and delete the material from any
computer. All e-mails sent from or to Fidelity Business Services India
Pvt. Ltd. may be subject to our monitoring procedures.
-----Original Message-----
From: Mary Chibwana
[mailto:oracledba-ezmlmshield-x7591475.[Email address protected]
Sent: Tuesday, August 02, 2005 5:39 PM
To: LazyDBA Discussion
Subject: invalid synonym
Hi guys,
I am gettig the following error when I try to access some synonym:
ORA-00980- synonym translation is no longer valid.
How can I make it valid again.
Please help.
Maria
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page