can we use materialized views (without query rewrite feature) in oracle standard edition ?
Our customer is having Oracle Sandard licence. We have developed our Product for Analytical reporting to use Materialized views as we use Oracle Enterprise Edition . Now we don't know if this will work on Oralcle Standard edition as well? While we are doing a POC for this, can someone confirm if they had similar challenge and what was the resolution given ? Can we use materialized views (without query rewrite feature) in oracle standard edition ? If Not What is the alternate ?
Thanks in Advance
Nishant Shrivastava