ORA-14405: partitioned index contains partitions in a different tablespace

ORA-14405: partitioned index contains partitions in a different tablespace
Cause: An attempt was made to drop a tablespace which contains indexes whose partitions are not completely contained in this tablespace, and which are defined on the tables which are completely contained in this tablespace.
Action: find indexes with partitions which span the tablespace being dropped and some other tablespace(s). Drop these indexes, or move the index partitions to a different tablespace, or find the tables on which the indexes are defined, and drop (or move) them.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14405：分区索引包含不同表空间中的分区,
.原因：尝试删除包含其分区未完全包含在此表空间中的索引的表空间，并且这些索引在完全包含在此表空间中的表上定义。,
.操作：查找具有跨被删除的表空间的分区的索引和某些其他表空间。删除这些索引，或将索引分区移动到不同的表空间，或找到定义索引的表，并删除（或移动）它们。,
.

aiaiDBA

13718043309

010-86462881

ORA-14405: partitioned index contains partitions in a different tablespace

1 个回答

相似问题