Synonym problem over materialized view
609621Feb 6 2011 — edited Jun 29 2011Dear all,
10.2.0.4 on solaris 10
When trying to create a materialzed view (accessing a object over a dblink) am getting the below error :
ORA-00980 : Synonym Translation is no longer valid
query used :
create materialized view mvtelco as select * from list@ptelco where sdate between '09-jan-11' and '10-jan-11';
gives the above error
where as the query executes and retruns rows
select * from list@ptelco where sdate between '09-jan-11' and '10-jan-11';
I am able to create the view.
Any idea
Kai