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

Cause: 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

Action: Do not use unsupported types of interim tables.

Error Type: ORA

• Additional information for ORA-42020: partition cannot be redefined online because of unsupported type of interim table42020
Discussions and solutions for Oracle Database Error ORA-42020: partition cannot be redefined online because of unsupported type of interim table Developer anwers for Oracle Database Error ORA-42020: partition cannot be redefined online because of unsupported type of interim table FAQs for ORA-42020: partition cannot be redefined online because of unsupported type of interim table search others tips for ORA-42020: partition cannot be redefined online because of unsupported type of interim table