Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-42001: online redefinition options require COMPATIBLE parameter to be [string] or greater
Oracle® Database Error ORA-42001181/24

ORA-42001: online redefinition options require COMPATIBLE parameter to be [string] or greater

Cause: The following types of redefinition require a 10.2 or higher compatibility setting:o redefining a materialized view logo redefining a table with objectso redefining a clustered tableo redefining an AQ queue tableo redefining a table partition The following types of redefinition require an 11.0 or higher compatibility setting:o redefining a table with a materialized view logo redefining a table with dependent materialized views

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

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle