Mike,
You missing this field:
count(trn_reserve) cnt_tot_res
Cheers,
Vadim Gorbounov
Oracle DBA
724 Solutions Inc.
Tel:(416)226-2900 ext 5070
Email: [EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, April 16, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
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
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vadim Gorbounov
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
