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 [EMAIL PROTECTED]
*
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 !
