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.
: at SYS.DBMS_SNAPSHOT, line 852
ORA-06512: at line 1
Mike
From: Vadim Gorbounov [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Fast refresh materialized view is not updateable
Date: Tue, 16 Apr 2002 13:53:29 -0800
Mike
]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Fast refresh materialized view is not updateable
Date: Tue, 16 Apr 2002 13:53:29 -0800
Mike,
You missing this field:
count(trn_reserve) cnt_tot_res
Cheers,
Vadim Gorbounov
Oracle DBA
724 Solutions Inc.
Tel:(416)226