RE: Fast refresh materialized view is not updateable

2002-04-16 Thread Khedr, Waleed
ot;SCD_FINANCIAL_SUMMARY_PIT_MV1" is INVALID and must complete refresh ORA-06512: at "SYS.DBMS_SNAPSHOT", line 814 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 872 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 852 ORA-06512: at line 1 Mike >From: Vadim Gorbounov <[EMAIL P

RE: Fast refresh materialized view is not updateable

2002-04-16 Thread Vadim Gorbounov
S_SNAPSHOT", line 814 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 872 ORA-06512: 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 <

RE: Fast refresh materialized view is not updateable

2002-04-16 Thread Mike Killough
.DBMS_SNAPSHOT", line 814 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 872 ORA-06512: 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 &l

RE: Fast refresh materialized view is not updateable

2002-04-16 Thread Vadim Gorbounov
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 cr

Fast refresh materialized view is not updateable

2002-04-16 Thread Mike Killough
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. He