partitioned table contains subpartitions in a different tablespace

Solution ID:ORA-14407

Type: Oracle

Cause

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

Actions

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

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/11185563


https://community.oracle.com/message/4097443


https://community.oracle.com/message/11108258


https://community.oracle.com/message/11211944


Browse all solutions to database errors from Oracle, MS SQL, or MySQL