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

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:52

ORA-42020：由于不支持的临时表类型，无法在线重新定义分区,
.原因：在分区重新定义期间提供了不支持的临时表类型。目前不支持以下类型的临时表：,
.- 嵌套表或具有嵌套表列,
.,
.- 外部表,
.,
.- 集群的一部分,
.,
.- 包含LOB共享段,
.,
.操作：不要使用不支持的临时表类型。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题