select table_name,tablespace_name from user_tables where tablespace_name = '表空间名';
SELECT S.TABLESPACE_NAME, S.TABLE_NAME FROM DBA_TABLES S ORDER BY 1, 2;
describe dba_tables; select table_name,[the member of the result of describe] from dba_tables;
改改. select table_name, tablespace_name from dba_tables where tablespace_name = upper('表空间名');
select table_name, tablespace_name from dba_tables where tablespace_name = upper('表空间名');
SELECT tablespace_name 表空间,sum(blocks*8192/1000000) 剩余空间M FROM dba_free_space GROUP BY tablespace_name;select b.name,sum(a.bytes/1000000)总空间 from v$datafile a,v$tablespace b where a.ts#=b.ts# group by b.name;
where tablespace_name = '表空间名';
SELECT S.TABLESPACE_NAME, S.TABLE_NAME FROM DBA_TABLES S ORDER BY 1, 2;
select table_name,[the member of the result of describe] from dba_tables;
select table_name, tablespace_name
from dba_tables
where tablespace_name = upper('表空间名');
from dba_tables
where tablespace_name = upper('表空间名');
FROM dba_free_space GROUP BY tablespace_name;select b.name,sum(a.bytes/1000000)总空间
from v$datafile a,v$tablespace b where a.ts#=b.ts# group by b.name;