ORA-14407: partitioned table contains subpartitions in a different tablespace

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

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

Error Type: ORA

• Additional information for ORA-14407: partitioned table contains subpartitions in a different tablespace14407
Discussions and solutions for Oracle Database Error ORA-14407: partitioned table contains subpartitions in a different tablespace Developer anwers for Oracle Database Error ORA-14407: partitioned table contains subpartitions in a different tablespace FAQs for ORA-14407: partitioned table contains subpartitions in a different tablespace search others tips for ORA-14407: partitioned table contains subpartitions in a different tablespace