Oracle Error ORA-42020: partition cannot be redefined online because of unsupported type of interim table

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.