Database Software

Hi guys,

I need a local replication of some data tables from a remote Oracle machine, so I decided using Materialized View as solution with a DataBase Link, but when trying to create the MV, I get the following:


CREATE MATERIALIZED VIEW foo REFRESH FAST
START WITH SYSDATE NEXT SYSDATE + 1/(60*24) AS
SELECT DISTINCT
FROM table1@DBLINK t1,
table2@DBLINK t2
WHERE t1.id = t2.id
ORDER BY t1.id;


CREATE MATERIALIZED VIEW foo REFRESH FAST
***
ERROR at line 1:
ORA-00980: synonym translation is no longer valid


I can make the Select query with no problem and the user that uses the DBLink has the next privileges:

CREATE DATABASE LINK
CREATE PUBLIC SYNONYM
CREATE SESSION
CREATE SYNONYM
SELECT ANY TABLE

I'm using Oracle 10.2.0.1.0 in a Windows Server 2003 machine.

Any help would be appreciated. Thanks a lot.

Juan