Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h34BZqJ00437 for ; Fri, 4 Apr 2003 05:35:52 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h34BZog00430 for ; Fri, 4 Apr 2003 05:35:50 -0600 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id AAA32394; Fri, 4 Apr 2003 00:14:36 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0057A1E6; Thu, 03 Apr 2003 23:18:36 -0800 Message-ID: Date: Thu, 03 Apr 2003 23:18:36 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Dilip" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Dilip" Subject: strange ORA- 00980 - synonym translation is no longer valid Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/mixed; --=_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@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

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@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-- --=_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" UmVwb3J0aW5nLU1UQTogZG5zOyBXUzAwMDUuaW5kaWF0aW1lcy5jb20KUmVjZWl2ZWQtRnJvbS1N VEE6IEROUzsgYTIKQXJyaXZhbC1EYXRlOiBGcmksIDQgQXByIDIwMDMgMTE6NDU6MDIgKzA1MzAK CkZpbmFsLVJlY2lwaWVudDogUkZDODIyOyBPUkFDTEUtTEBmYXRjaXR5LmNvbQpBY3Rpb246IGZh aWxlZApTdGF0dXM6IDUuMS4xClJlbW90ZS1NVEE6IEROUzsgbWgyLmN0cy5jb20KRGlhZ25vc3Rp Yy1Db2RlOiBTTVRQOyA1NTAgPE9SQUNMRS1MQGZhdGNpdHkuY29tPi4uLiBSZWxheWluZyBkZW5p ZWQKTGFzdC1BdHRlbXB0LURhdGU6IEZyaSwgNCBBcHIgMjAwMyAxMTo0NTowNSArMDUzMAo= --=_MAILER_ATTACH_BOUNDARY_2003445124634233665123-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dilip INET: dilip7772002@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@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).