How to enable "Materialized view rewrite"

May 25, 2024 11:45AM

Hello All

All feedback welcome

Is it possible to purchase option "Materialized view rewrite" for Standard Edition 2 ?

SQL> SELECT banner_full FROM v$version;

BANNER_FULL

Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.21.0.0.0

SQL> SHOW PARAMETER query_rewrite

NAME TYPE VALUE

query_rewrite_enabled string TRUE
query_rewrite_integrity string enforced

SQL> select * from v$option where lower(parameter) = 'materialized view rewrite';

VALUE CON_ID

Materialized view rewrite
FALSE 0

ORA-00439

Steve