Problem when create materialized view
When I create the materialized view, error ORA-32401 is prompted. However, I don't know the meaning of this error.
//Quote//
1 create materialized view mv_test_trans
2 refresh fast on demand
3 as
4 select c.name, sum(t.trx_amt) as total
5 from dm_cust_master c, test_trans t
6 where c.cust_uid = t.cust_uid
7* group by c.name
CRDW>/
from dm_cust_master c, test_trans t
*
ERROR at line 5:
ORA-32401: materialized view log on "CRDW"."TEST_TRANS" does not have new values
//Un Quote//
