ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables

ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables
Cause: The clause INVALIDATE or UPDATE GLOBAL INDEXES is allowed only for ADD partition to a HASH partitioned table or ADD subpartition to a composite partitioned table.
Action: Remove clause and reissue operation

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-30564：不允许将索引维护子句用于对RANGE分区表的ADD分区,
.原因：子句INVALIDATE或UPDATE GLOBAL INDEXES仅允许对HASH分区表或ADD子分区到复合分区表的ADD分区。,
.操作：删除子句和重新发布操作,
.

aiaiDBA

13718043309

010-86462881

ORA-30564: Index maintainence clause not allowed for ADD partition to RANGE partitioned tables

1 个回答

相似问题