ORA-04052 error when create a MV reference a remote table,
Synonym on USCDWDBP database over public database link uscumsp.
create synonym dwdb_admin_syn.PARSER_HEADER from ums_dba.parser_header@uscumsp;
and normal sql query run by dwb_admin_syn "select * from dwdb_admin_syn.PARSER_HEADER" works fine.
but when i run below statements to create materialized view runtens error:
15:17:57 DWDB_ADMIN_SYN@ uscdwdbp>CREATE MATERIALIZED VIEW MV_PARSER_HEADER ON PREBUILT TABLE REFRESH FAST ON DEMAND AS SELECT "PARSER_HEADER"."GUID" "GUID","PARSER_HEADER"."DEVICE" "DEVICE","PARSER_H
EADER"."CUSTLOTID" "CUSTLOTID","PARSER_HEADER"."TIMESTAMP" "TIMESTAMP","PARSER_HEADER"."PARSER" "PARSER","PARSER_HEADER"."FILENAME" "FILENAME","PARSER_HEADER"."CUST_CODE" "CUST_CODE" FROM "PARSER_HEAD