dbms_mview.estimate_mview_size
ORA-30475: feature not enabled: Java
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SUMADVISOR", line 2308
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3283
ORA-06512: at line 321
V$options lists JAVA true but apparently, I don't have JVM installed per dba_registry.
Are there other options and/or features are needed? Is the use of this procedure already included in the cost of an enterprise license with the diagnostic and tuning packs?
This is my test case (works in a different environment but not in my datamart).