无法删除表空间,ORA-23515

删除某个表空间提示ORA-23515: materialized views and/or their indices exist in the tablespace

因为该表空间存在物化视图，所以必须先找出该表空间的物化视图，并先删除掉该物化视图，然后继续删除表空间:

select table_name, tablespace_name from dba_tables
where tablespace_name='ZFS_SYS' and table_name in (select mview_name from dba_mviews);