This content has been marked as final. Show 4 replies
Virtual REFs created via MAKE_REF cannot be inserted in a physical table.
Are you trying to create an object MV out of relational data ?
Could you explain your requirement with some sample data ?
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.