Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    16

    Unanswered: ORA-12054: cannot set the ON COMMIT refresh attribute..very urgent

    Hi All

    I'm getting following error when i'm trying to Create a Materialized View with REFRESH FORCE ON COMMIT' option.

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

    Following is the code i'm trying with:


    CREATE MATERIALIZED VIEW LOG ON test1 TABLESPACE tab1 NOLOGGING;

    CREATE MATERIALIZED VIEW LOG ON test2 TABLESPACE tab1 NOLOGGING;

    CREATE MATERIALIZED VIEW LOG ON test3 TABLESPACE tab1 NOLOGGING;

    CREATE MATERIALIZED VIEW LOG ON test4 TABLESPACE tab1 NOLOGGING;

    CREATE MATERIALIZED VIEW TEST_MV
    TABLESPACE TAB1
    NOLOGGING
    REFRESH FORCE ON COMMIT
    AS
    SELECT
    col1 column1,
    col2 column2,
    DECODE(col3,1,'one','zero') column3,
    DECODE(col4,1,'one','zero') column4
    FROM
    test1,
    test2,
    test3,
    test4;

    Is this b'cos of using the DECODE Functions in the View Source. If so, is there any way to Create a Materialized View with REFRESH FORCE ON COMMIT option that contains DECODE Functions.

    Any one please let me know..........its very urgent

    Many Thanks
    DBSTARTER

  2. #2
    Join Date
    Jan 2005
    Posts
    1

    hi

    Hello,

    In my understanding, you should remove nologing in your creation of

    materialized view log

  3. #3
    Join Date
    Jan 2005
    Posts
    3
    Take a look at
    http://dbis.informatik.uni-freiburg..../a90237/mv.htm

    and scroll down to "Materialized Views Containing Only Joins"

    Hope this helps.

Posting Permissions

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