查看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";
查看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";