Cause: An attempt was made to drop a tablespace which contains materialized views and/or their indices. See the solution below.
Error solution: Drop the materialized views in this tablespace. Also, find indices belonging to materialized views in this tablespace and drop then. Then try dropping the tablespace.
Database version: Oracle 11g Release 2 (11.2)