Oracle Solution for Error ora-42020
ORA-42020: partition cannot be redefined online because of unsupported type of interim table
What triggered 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 column.
*- an external tabl.
*- part of cluste.
*- contains LOB shared segment.
What should we do to fix it:
Do not use unsupported types of interim tables.