can't set the ON COMMIT refresh attribute
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: can't set the ON COMMIT refresh attribute

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    can't set the ON COMMIT refresh attribute

    I am trying to create this MVIEW on my replication database and get the erorr below. Can somebody tell me what is wrong and how I can correct it.

    SQL> CREATE PUBLIC SYNONYM abc for pbh.abc;
    Synonym created.

    CREATE MATERIALIZED VIEW abc
    REFRESH ON COMMIT
    AS SELECT * FROM abc@PRI;

    $ oerr ora 12054
    12054, 00000, "cannot set the ON COMMIT refresh attribute for the materialized view"
    // *Cause: The materialized view did not satisfy conditions for refresh at
    // commit time.
    // *Action: Specify only valid options.

  2. #2
    Join Date
    Feb 2009
    Posts
    91
    All:

    I did some experimenting and finally found from Oracle that "on commit" you can use only if you have your master table in the same database where you are creating MView. Therefore, on commit is not suported in remote databases. Another way you can use remote database if you replace your line "REFRESH ON COMMIT" with "refresh fast on demand with primary key" and this works.

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