http://www.iteye.com/topic/620306/

 

查询表空间名字和状态

select tablespace_name,status FROM dba_tablespaces;