ORA-14404: partitioned table contains partitions in a different tablespace ORACLE 报错 故障修复 远程处理

文档解释

ORA-14404: partitioned table contains partitions in a different tablespace

Cause: An attempt was made to drop a tablespace which contains tables whose partitions are not completely contained in this tablespace

Action: find tables with partitions which span the tablespace being dropped and some other tablespace(s). Drop these tables or move partitions to a different tablespace

ORA-14404 错误表示有一个 ORACLE 分区表包含分区放在不同的表空间中，出现这个错误会导致该表的操作失败。

官方解释

常见案例

正常处理方法及步骤

1.查找出拥有不属于一个表空间的分区，使用以下命令查询：

SELECT * FROM dba_tab_partitions WHERE tablespace_name NOT IN (SELECT tablespace_name FROM dba_tables WHERE table_name = ‘表名’);

2.更新那些分区的表空间，使用下边的命令将它们改为统一的表空间：

ALTER TABLE 表名 MODIFY PARTITION 分区名 TABLESPACE 表空间;

3.再次查询查看上述分区是否被修改：

SELECT * FROM dba_tab_partitions WHERE tablespace_name NOT IN (SELECT tablespace_name FROM dba_tables WHERE table_name = ‘表名’);

4. 确认上述步骤后，分区表空间统一，此时就可以正常地使用这个表了，也可以正常进行插入，删除，修改等操作了。