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.
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 !
Below is the sample query extracted from the main query.
this is a view query only . I need to make Materialized view from this. Can you please suggest any alternate way to achieve the same.
MAKE_REF(TASK_DTLS_v, DECODE(BTV.ROWID_TASK,NULL,'°',BTV.ROWID_TASK) ) TASK,
MAKE_REF(PROJEKTTYP_v, DECODE(P.ROWIDPROJECT,NULL,'°',P.ROWIDPROJECT) ) PROJECT
WHERE BT.PSYBAUTEILID = P.PSYBAUTEILID
AND BTV.PSYBAUTEILVERSIONID = BT.PSYBAUTEILVERSIONID ;
yes may be you are right. I am trying to make M-view from relational data. As the view contains periodic data so for the performance improvement it is to be converted into m-view.
can you please suggest any other approach instead of Make_Ref. ?
Thanks in advance!
"can you please suggest any other approach instead of Make_Ref. ?"
Just a thought, but can you create a materialized view containing only the needed object view key columns, then create a view on that where you construct your REF columns.