Cause
An attempt was made to drop a tablespace which contains tables whose subpartitions are not completely contained in this tablespace
An attempt was made to drop a tablespace which contains tables whose subpartitions are not completely contained in this tablespace
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