-
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//
-
fantastic bit of new for the oracle world there, thanks
hint: try posting in the right forum
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|