Oracle Error Message
ORA-42020: partition cannot be redefined online because of unsupported type of interim table
Reason for the Error
An unsupported type of interim table was provided during the partition redefinition. Currently the following types of interim tables are not supported:
– a nested table or has nested-table columns
– an external table
– part of cluster
– contains LOB shared segments
Solution
Do not use unsupported types of interim tables.