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
- one is index-organized and the other is not
- one has IOT overflow segment and the other does not
- one has IOT mapping table and the other does not
- a nested table or has nested-table columns
- an external table
- part of cluster
- contains LOB shared segments