Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Leiden, The Netherlands

    Unanswered: materialized view

    Is it possible to use a materialized view on Oracle 9 that uses a table in an Oracle 8.1 database as base table? I use a database link. It has to refresh on commit.

    create materialized view mv_table1 refresh on commit as select * from table1@ora8;

    ERROR at line 1:
    ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

    I have made a materialize view log on table1 but that doesn't help.

  2. #2
    Join Date
    Jul 2003
    I think due to the dblink, the MV would have no way of knowing when a commit was issued on the dblink-table.

    Could be a privs situation perhaps as well.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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