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