Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    10

    Question Unanswered: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized

    - When I create Materialized View:

    CREATE MATERIALIZED VIEW "MVADMIN"."DMBANGCAP"
    BUILD IMMEDIATE
    REFRESH FAST
    ON COMMIT
    AS
    SELECT BCMA AS MABANGCAP, BCTEN AS TENBANGCAP FROM HOSOCANBO.BANGCAP@NDLINH


    I meet error like this:
    ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized
    view

    I has granted ON COMMIT REFRESH privilege to MVADMIN.
    Please help me
    yancancook

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    You can't refresh a materialized view ON COMMIT when it selects across a dblink. Your database doesn't know about commits taking place in the remote database.

    You would need to look at Advanced Replication to achieve this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •