I want to replicate a table which contains a blob field from a 11g database to an 11g XE using materialized view replication. The problem is, that I use a subquery to create the MV on the client. I want to use the REFRESH FAST option for the MV. The subquery works with other tables that do not have a blob item.
When I omit the subquery for the MV, then replication works perfectly. When I use a subquery for the MV I get the following error during a refresh on the client:
ORA-12048: error encountered while refreshing materialized view "MDS_ADMIN"."DRAWIN"
ORA-04054: Datenbank-Link XEKRIEGE.HMB.HMBNET ist nicht vorhanden -> translated: database link XEKRIEGE.HMB.HMBNET does not exist
ORA-02063: preceding line from TMDS.HMB.HMBNET
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2566
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2779
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 2
where MDS_ADMIN.DRAWIN is the table/MV that contains the blob field, XEKRIEGE.HMB.HMBNET is the client and TMDS.HMB.HMBNET the master.