9 Replies Latest reply: Nov 20, 2012 8:47 PM by dba7188@ RSS

    Create Materialized View  based on another database table using db link?

    879152
      SQL> SELECT sysdate
      2 FROM dual@CBRLINK ;

      SYSDATE
      ---------
      21-NOV-12

      SQL> CREATE MATERIALIZED VIEW USERCBR.V_T24_COUNTRY1
      2 REFRESH COMPLETE
      3 START WITH SYSDATE NEXT SYSDATE + (5/24)
      4 AS
      5 SELECT sysdate
      6 FROM dual@CBRLINK ;
      CREATE MATERIALIZED VIEW USERCBR.V_T24_COUNTRY1
      *
      ERROR at line 1:
      ORA-04052: error occurred when looking up remote object SYS.DUAL@CBRLINK
      ORA-00600: internal error code, arguments: [ORA-00600: internal error code,
      arguments: [qksfroFXTStatsLoc() - unknown KQFOPT type!], [0], [], [], [], [],
      [], [], [], [], [], []
      ], [], [], [], [], [], [], [], [], [], [], []
      ORA-02063: preceding line from CBRLINK