Forum Stats

  • 3,814,867 Users
  • 2,258,922 Discussions
  • 7,892,882 Comments

Discussions

Oracle XE 18c and MV-Logs

Oracle XE 11c does not support creating materialized view logs.

Can anyone tell me, whether Oracle XE 18c (and further) do support that?

Thanks and regards.

Rolf

Tagged:

Answers

  • Mathias Zarick
    Mathias Zarick Member Posts: 106 Silver Badge

    HI Rolf,

    yes MV logs work.

    See this:

    SQL> SELECT banner FROM v$version;


    BANNER

    --------------------------------------------------------------------------------

    Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production


    SQL> CREATE TABLE x (a INT);


    Table created.


    SQL> ALTER TABLE x ADD CONSTRAINT x_pk PRIMARY KEY (a);


    Table altered.


    SQL> CREATE MATERIALIZED VIEW LOG ON x;


    Materialized view log created.


    SQL> CREATE MATERIALIZED VIEW m REFRESH FAST AS SELECT a FROM x;


    Materialized view created.


    SQL> EXEC dbms_mview.refresh('m','f');


    PL/SQL procedure successfully completed.


    In general it has more features compared to 11g, but also compared to 18c Standard Edition.

    More details can be found in this blog post:

    https://mathiaszarick.wordpress.com/2020/06/26/getting-the-most-out-of-oracle-database-express-edition-xe-18c/

    HTH Mathias