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

曾春华

ORA-42001: online redefinition optionsrequire COMPATIBLE parameter to be

string or greater

Cause: The following types ofredefinition 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 ofredefinition 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

Action: Shut down and restart with anappropriate compatibility setting.