1 Reply Latest reply: Jul 17, 2012 8:47 PM by ursusca RSS

    11G replication with blob field (ORA-04054)

    G. Krieger
      Hi all,

      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.

      Any ideas?

      Thanks in advance

      Gerald

      Edited by: G. Krieger on Jul 11, 2012 12:01 PM