4 Replies Latest reply: Mar 22, 2013 2:09 PM by gaverill RSS

    Use of MAKE_REF in Materialized view.

    Subhadeep Roy
      Hi All,

      I am trying to make a materialized view of a sql query where MAKE_REF function is used. While creating the materialized view, because of this, I am getting the belo error.

      Error report:
      SQL Error: ORA-22979: cannot INSERT object view REF or user-defined REF
      22979. 00000 - "cannot INSERT object view REF or user-defined REF"

      Can you please suggest what can be done to create the materialized view with same data?

      Thanks in advance !

      Cheers

      Roy