Materialized View
From: ExecMan <artmerar_at_yahoo.com>
Date: Wed, 16 May 2012 09:44:15 -0700 (PDT)
Message-ID: <f0810bf5-f2bf-443b-abbc-7c661180911f_at_e9g2000pbh.googlegroups.com>
Date: Wed, 16 May 2012 09:44:15 -0700 (PDT)
Message-ID: <f0810bf5-f2bf-443b-abbc-7c661180911f_at_e9g2000pbh.googlegroups.com>
Hi,
Can a materialized view be created based on an object table like this. I have a PL/SQL procedure which creates this object table and populates it, then I want to create a materialized view from it:
EXECUTE IMMEDIATE 'CREATE MATERIALIZED VIEW inst_holdings_mv AS SELECT * FROM TABLE(CAST(v_inst_hold_rec AS inst_holdings_table))';
I get an error:
ERROR at line 1:
ORA-00904: "V_INST_HOLD_REC": invalid identifier
ORA-06512: at line 44
Received on Wed May 16 2012 - 11:44:15 CDT