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).

Reply via email to