oracle数据库笔记
表空间大小:
SELECT tablespace_name, sum(bytes) / 1024 / 1024 “占用空间(MB)” FROM dba_data_files
GROUP BY tablespace_name;
查询单个表占用的大小;
SELECT segment_name, segment_type, bytes/1024/1024 AS MB
FROM user_segments
WHERE segment_type = ‘TABLE’
AND segment_name = ‘ETLODS_ZWWDHZB2021’;
##ETLODS_ZWWDHZB2021 具体表名
查找表所在的表空间
SELECT table_name, tablespace_name FROM user_tables WHERE table_name = ‘表名’;
查看表空间剩余的大小
select tablespace_name, sum(bytes)/(1024*1024) as free_space
from dba_free_space
group by tablespace_name;