ORA-00439: feature not enabled: Materialized view rewrite
Hi all,
i have Migrated from Enterprise 10gR2 to Standard Edition 11gR2. All is working fine except the creation of materialized views.
Please find scipts below: -
Create materialized view roc_name_view_mat_1
build immediate
enable query rewrite
as
select org_name,
org_file_no, decode( ORG_LAST_STA_CD,'LIV', 'LIVE',
'DOR', 'DORMANT',
'DRF', 'DRAFT',
'DEF', 'DEFUNCT',
'NAN*', 'NOT AVAILABLE NOW*') as ORG_LAST_STA_CD,
org_no,
org_incorp_dt,
cmpType.ref_desc as typeDesc,
comNat.ref_desc as natDesc,
cat_desc, sct_desc,
ads_address1, ads_address2, ads_address3,
ads_country_cd, cty.ref_desc ctyDesc,
i have Migrated from Enterprise 10gR2 to Standard Edition 11gR2. All is working fine except the creation of materialized views.
Please find scipts below: -
Create materialized view roc_name_view_mat_1
build immediate
enable query rewrite
as
select org_name,
org_file_no, decode( ORG_LAST_STA_CD,'LIV', 'LIVE',
'DOR', 'DORMANT',
'DRF', 'DRAFT',
'DEF', 'DEFUNCT',
'NAN*', 'NOT AVAILABLE NOW*') as ORG_LAST_STA_CD,
org_no,
org_incorp_dt,
cmpType.ref_desc as typeDesc,
comNat.ref_desc as natDesc,
cat_desc, sct_desc,
ads_address1, ads_address2, ads_address3,
ads_country_cd, cty.ref_desc ctyDesc,
0