ORA-12079: materialized view options require COMPATIBLE parameter to be string or greater

Cause: The following materialized view options require 8.1 or higher compatibility setting:

o ON COMMIT

o ON PREBUILT TABLE

o BUILD DEFERRED

o NEVER REFRESH

o ENABLE QUERY REWRITE The following materialized view options require 8.2 or higher compatibility setting:

o materialized views with user-defined types The following materialized view options require 9.2 or higher

o materialized views (query rewrite enabled) with set operators that are not inside an inline view or named view The following materialized view options require 10.0 or higher

o materialized views which can be refreshed USING TRUSTED CONSTRAINTS

o materialized views with SELECT column alias clause In addition, ALTER MATERIALIZED VIEW LOG can be used to add sequence number only if compatibility is set to 10.0 or higher

Action: Shut down and restart with an appropriate compatibility setting.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/