OraFAQ Forum: SQL & PL/SQL » PL/SQL: ORA-00980: synonym translation is no longer valid

Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL: ORA-00980: synonym translation is no longer valid

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

PL/SQL: ORA-00980: synonym translation is no longer valid [message #636932]

Tue, 05 May 2015 23:56

amit.sonar
Messages: 98
Registered: December 2009
Location: Mumbai

Member

Dear All,

I am facing one weird scenario in which I took production data dump and restored it on the other server. However One of packages became invalid after restoration. I checked the error and it was "PL/SQL: ORA-00980: synonym translation is no longer valid". Same package is valid in prod environment.

When I recompiled the package using command 'Alter package package_name compile': it recompiled successfully without any error.

Can anyone know what would be the possibility of package became invalid initially?

Regards,
Amit Sonar.

[Updated on: Tue, 05 May 2015 23:58]

Report message to a moderator

Re: PL/SQL: ORA-00980: synonym translation is no longer valid [message #636933 is a reply to message #636932]

Wed, 06 May 2015 00:09

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just a thought: because the package was imported before the synonym or rather the object pointed by the synonym.

[Updated on: Wed, 06 May 2015 00:10]

Report message to a moderator

Re: PL/SQL: ORA-00980: synonym translation is no longer valid [message #636934 is a reply to message #636933]

Wed, 06 May 2015 00:16

amit.sonar
Messages: 98
Registered: December 2009
Location: Mumbai

Member

Hi Michel,

Thank you for your quick response. However I think whenever we import dump oracle handles execution of objects as well as their dependency.

Regards,
Amit Sonar.

Report message to a moderator

Re: PL/SQL: ORA-00980: synonym translation is no longer valid [message #636935 is a reply to message #636934]

Wed, 06 May 2015 01:10

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oracle does not recompile all stored code afterwards (which may greatly increase import time) as it will do it when the this code will be called.

Report message to a moderator

Re: PL/SQL: ORA-00980: synonym translation is no longer valid [message #636971 is a reply to message #636935]

Wed, 06 May 2015 16:09

amit.sonar
Messages: 98
Registered: December 2009
Location: Mumbai

Member

Hi Michel

Thank you for quick reply and apologizing to reply late. If this is the case then need to write block to recompile considering dependencies.

Will write the block for the same.

Thanks & Regards,
Amit Sonar.

Report message to a moderator

Re: PL/SQL: ORA-00980: synonym translation is no longer valid [message #636972 is a reply to message #636971]

Wed, 06 May 2015 17:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/node/2008

Report message to a moderator

Previous Topic:	How to get the right information suggested about Date
Next Topic:	How to get count of character in the table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 07 18:47:14 CDT 2025