Oracle XE 18c and MV-Logs

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