Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Fast refresh materialized view is not updateable
I create a fast refresh materialized view that is a single table
aggregation, but dml on the base table does not update the materialized
view. In dba_mviews, FAST_REFRESHABLE = DIRLOAD_LIMITEDDML. I think that I
have satisfied the requirements for a fast refresh MV. I can't see the
problem. Here is a stripped down version of the view, that can be created,
but is not updateable:
create materialized view log on scd_financial_detail
tablespace &&tbsname
with rowid (claim_carrier_key, eval_date, trn_reserve)
including new values
;
create materialized view scd_financial_summary_pit_mv
tablespace &&tbsname build immediate refresh fast on commit with rowid enable query rewrite AS select count(*), claim_carrier_key, eval_date, sum(trn_reserve) fin_tot_res from scd_financial_detail group by claim_carrier_key, eval_date
Could anyone please tell me what I'm missing?
Thanks,
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: mwkillough_at_hotmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 16 2002 - 15:13:51 CDT
![]() |
![]() |