tag:blogger.com,1999:blog-7395977411859619892.post7449924913396712565..comments2024-01-30T09:21:06.579+01:00Comments on About Oracle: Fast refreshable materialized view errors, part four: union all MV'sRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-7395977411859619892.post-79554598880483706712009-08-11T14:14:54.705+02:002009-08-11T14:14:54.705+02:00Looking at your query you seem to have run it on 1...Looking at your query you seem to have run it on 11 but on 9iR2 no chance<br /><br />create materialized view MV_CALL_SERVICE_TYPE<br /> refresh fast on commit as<br />SELECT TB_ROW_ID,AREA,SITE,CDN_NAME,DESTINATION_KEY, DESTINATION,LOAD_DATE <br /> FROM (<br /> SELECT rowid tb_row_id ,<br /> 'DBT' area,<br /> 'MN' site,<br /> campaign_name cdn_name,<br />Unknownhttps://www.blogger.com/profile/10931264964805760635noreply@blogger.com