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.
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.
No comments:
Post a Comment