ORA-19728: data object number conflict between table string and partition string in table string

ORA-19728: data object number conflict between table string and partition string in table string
Cause: The non-partitioned table has the same data object number as one of the partitions in the partitioned table. One can not exchange the table with the partition in this case.
Action: Use "alter table move partition" command to move the offending partition, so that the partition will get a new data object number. Retry the operation then.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:44

ORA-19728：表之间的数据对象编号冲突字符串和分区字符串表字符串,
.原因：未分区表具有与分区表中的一个分区相同的数据对象编号。在这种情况下，无法与分区交换表。,
.操作：使用“alter table move partition”命令移动有问题的分区，以便分区将获取一个新的数据对象编号。然后重试操作。,
.

aiaiDBA

13718043309

010-86462881

ORA-19728: data object number conflict between table string and partition string in table string

1 个回答

相似问题