Oracle Error ORA-42001: online redefinition options require COMPATIBLE parameter to be string or greater

Oracle Error Message

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

Reason for the Error

The following types of redefinition require a 10.2 or higher compatibility setting:

o redefining a materialized view log

o redefining a table with objects

o redefining a clustered table

o redefining an AQ queue table

o 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 log

o redefining a table with dependent materialized views

Solution

Shut down and restart with an appropriate compatibility setting.