DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005

    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.

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

  2. #2
    Join Date
    Sep 2002
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.