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.
