æ¥çé£äºåºçè¯å¿
é¡»ç¨dbaæéç»å½ãç»éåå¯ä»¥éè¿ä¸é¢çæ¹æ³æ¥æ¥çã
ä¸ãæ¥çæåªäºåºï¼ä½ çåºç解ä¸åç¡®ï¼åºè¯¥åç¡®æ¥è¯´æ¯è¡¨ç©ºé´ï¼å¯ä»¥éè¿ä¸é¢çå½ä»¤æ¥å®ç°
SELECT Total.name "Tablespace Name",
Free_space, (total_space-Free_space) Used_space, total_space
FROM
(select tablespace_name, sum(bytes/1024/1024) Free_Space
from sys.dba_free_space
group by tablespace_name
) Free,
(select b.name, sum(bytes/1024/1024) TOTAL_SPACE
from sys.v_$datafile a, sys.v_$tablespace B
where a.ts# = b.ts#
group by b.name
) Total
WHERE Free.Tablespace_name = Total.name
äºãæ¥çæåªäºè¡¨ã
select table_name from dba_tables where owner='A';
温馨提示:答案为网友推荐,仅供参考