Question: I am getting the ORA-14407
error when trying to drop a tablespace after moving
subpartitions to another tablespace:
DROP TABLESPACE
PART_TS INCLUDING CONTENTS AND DATAFILES;
*
ERROR at
line 1:
ORA-14407: partitioned table contains
subpartitions in a different tablespace
How do I resolve the ORA-14407 error?
Answer:
The oerr utility shows this for the ORA-14407
error:
oerr ORA 14407
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
For more details on the ORA-14407 error resolution, see
MOSC Note
(1583130.1)
titled "ORA-14407 When Dropping a
Tablespace". One solution is to use the
dbms tts package (transportable tablespaces) to move the
tablespace subpartitions.
