ORA-23515

Error: ORA-23515: materialized views and/or their indices exist in the tablespace

Causa: An attempt was made to drop a tablespace which contains materialized views and/or their indices.

Acción: 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.