Oracle Solution for Error ora-14407

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

What triggered the Error:

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

What should we do to fix it:

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