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. -- //www.freelists.org/webpage/oracle-l