DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Problem when create materialized view

  1. #1
    Join Date
    Jun 2005
    Posts
    1

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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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