strange ORA- 00980 - synonym translation is no longer valid

--=_MAILER_ATTACH_BOUNDARY_2003445124634233665123 Content-Type: multipart/alternative;

           boundary="=_MAILER_ATTACH_BOUNDARY1_20034451246342145174067"

--=_MAILER_ATTACH_BOUNDARY1_20034451246342145174067 Content-Type: text/plain; charset=us-ascii

Hi List,

I have one Oracle Application database ( Version 8.1.7.4 on Sun Sparc Solaris 2.6, instace name CRPHR). I have a table HR_LOCATIONS_ALL in HR schema and there is synonym HR_LOCATIONS_ALL in APPS schema for this table.

I am trying to create a snapshot in other database ( Version 9.2 on Windows 2000) but that is failing with ORA-00980 error. The error is as follows.

create snapshot hr_locations_all

refresh WITH ROWID

as select

LOCATION_ID , < all other columns)...

from APPS.hz_locations_at_INST816.US.ORACLE.COM

*

ERROR at line 117:

ORA-00980: synonym translation is no longer valid

I have dropped and recreated the synonym in APPS schema. But no use. I can create the same snapshot in that same CRPHR database. There is no problem with database link. I was able to create around 60 snapshots but failing only on 2 snapshots.

Has anybody encounered this before ? Any idea ??

Regards,

Dilip
Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !

--=_MAILER_ATTACH_BOUNDARY1_20034451246342145174067 Content-Type: text/html; charset=us-ascii

<P><BR>Hi List,</P>
<P>I have one Oracle Application database (&nbsp;Version 8.1.7.4 on Sun Sparc Solaris 2.6, instace name CRPHR). I have a table HR_LOCATIONS_ALL in HR schema and there is synonym HR_LOCATIONS_ALL in APPS schema for&nbsp;this table.</P>
<P>I am trying to create a snapshot in&nbsp;other database ( Version 9.2 on Windows 2000) but that is failing with ORA-00980 error. The error is as follows.<FONT size=2></FONT></P>
<P><FONT size=2>create snapshot hr_locations_all <FONT size=2></FONT></FONT></P>
<P><FONT size=2><FONT size=2>refresh WITH ROWID</FONT><FONT size=2><FONT size=2></FONT></FONT></FONT></P>
<P><FONT size=2><FONT size=2><FONT size=2>as select</FONT></FONT><FONT size=2><FONT size=2><FONT size=2></FONT></FONT></FONT></FONT></P>
<P><FONT size=2><FONT size=2><FONT size=2><FONT size=2>LOCATION_ID ,</FONT></FONT></FONT></FONT></P>
<P><FONT size=2>&lt; all other columns)...<FONT size=2></FONT></FONT></P>
<P><FONT size=2><FONT size=2><FONT size=2>from <A href="mailto:APPS.hz_locations_at_INST816.US.ORACLE.COM">APPS.hz_locations_at_INST816.US.ORACLE.COM</A></FONT></FONT><FONT size=2><FONT size=2></FONT></FONT></FONT></P>
<P><FONT size=2><FONT size=2><FONT size=2>*</FONT></FONT><FONT size=2><FONT size=2></FONT></FONT></FONT></P>
<P><FONT size=2><FONT size=2><FONT size=2>ERROR at line 117:</FONT></FONT><FONT size=2><FONT size=2></FONT></FONT></FONT></P>
<P><FONT size=2><FONT size=2><FONT size=2>ORA-00980: synonym translation is no longer valid</FONT></FONT></FONT></P>
<P>-------------------</P>
<P>I have dropped and recreated the synonym in APPS schema. But no use. I can create the same snapshot in that same CRPHR database. There is no problem with database link. I was able to create around 60 snapshots but failing only on 2 snapshots. </P>
<P>Has&nbsp;anybody encounered this before ? Any idea ??</P>
<P>Regards,</P>
<P>Dilip</P>
<hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at </font>http://email.indiatimes.com</b><br>Buy The Best In <b>BOOKS</b> at http://www.bestsellers.indiatimes.com<br>Bid for <b>Air Tickets @ Re.1</b> on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now !</font>

--=_MAILER_ATTACH_BOUNDARY1_20034451246342145174067-- --=_MAILER_ATTACH_BOUNDARY_2003445124634233665123

Content-Type: /DELIVERY-STATUS; name="1967513926.DELIVERY-STATUS"
Content-Transfer-Encoding: BASE64
Content-Description: 1967513926.DELIVERY-STATUS
Content-Disposition: attachment; filename="1967513926.DELIVERY-STATUS" 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dilip
  INET: dilip7772002_at_indiatimes.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).