Got a query that will map an mview to a tablespace? I don't.

SQL> drop tablespace fred including contents and datafiles;
drop tablespace FRED including contents and datafiles
*
ERROR at line 1:
ORA-23515: materialized views and/or their indices exist in the tablespace

I worked around this in another fashion, but I couldn't find this
map quickly.

No gui junk please.
--
http://www.freelists.org/webpage/oracle-l