ORA-39283: Cannot drop, split or merge hash partition: string

ORA-39283: Cannot drop, split or merge hash partition: string
Cause: DBMS_METADATA_DIFF was comparing two tables or indexes partitioned or subpartitioned by hash, and a (sub)partition in the first object was not present in the second object. Partition maintenance operations such as drop, split or merge can only be performed on list or range (sub)partitioned objects.
Action: The difference cannot be eliminated with an SQL ALTER statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:52

ORA-39283：无法删除，拆分或合并散列分区：字符串,
.原因： DBMS_METADATA_DIFF正比较由散列分区或子分区的两个表或索引，并且第一个对象中的（子）分区不存在于第二个对象中。分区维护操作（例如删除，拆分或合并）只能在列表或范围（子）分区对象上执行。,
.操作：使用SQL ALTER语句无法消除该差异。,
.

aiaiDBA

13718043309

010-86462881

ORA-39283: Cannot drop, split or merge hash partition: string

1 个回答

相似问题