Oracle DB 问题小结(持续更新)

(1)DBLink, Materialized View and "synonym translation is no longer valid"
solution:
check the synonym sql is correct.especially point the remote schema of the table.

example:

CREATE MATERIALIZED VIEW foo REFRESH FAST
START WITH SYSDATE NEXT SYSDATE + 1/(60*24) AS
SELECT DISTINCT
FROM synonym1 t1,

***
ERROR at line 1:
ORA-00980: synonym translation is no longer valid

problem:
modify

create or replace synonym "your_schema"."synonym1 " FOR "table1"@"xx.CN.ORACLE.COM";

to

create or replace synonym "your_schema"."synonym1 " FOR "remote_schema"."table1"@"xx.CN.ORACLE.COM";