关于表空间

查看oracle表空间列表：SELECT * from V$TABLESPACE
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_name;

 查表空间的数据的sql:
select   *   from   dba_tables   where   tablespace_name="XXX";