1 先找到 查看表所占空间SELECT TABLESPACE_NAME,TO_CHAR(SUM(BYTES)/(1024*1024),'999G999D999') CNT_MB FROM DBA_EXTENTS WHERE OWNER='&OWNER' AND SEGMENT_NAME='&TABLE_NAME' AND SEGMENT_TYPE LIKE 'TABLE%' GROUP BY TABLESPACE_NAME; 2 在建表空间 /** 创建数据表空间***/ create tablespace xx_dat logging datafile '/home/oracle/oradata/orcl/xx_dat01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local
查看各表大小: SELECT SEGMENT_NAME,SUM(BYTES)/1024/1024|| 'M ' 大小 FROM DBA_SEGMENTS WHERE 1=1 AND OWNER= 'XXXXX' ----XXXXX改成你的owner AND SEGMENT_TYPE= 'TABLE' GROUP BY SEGMENT_NAME;
试一下看看行不行
查看表所占空间SELECT TABLESPACE_NAME,TO_CHAR(SUM(BYTES)/(1024*1024),'999G999D999') CNT_MB
FROM DBA_EXTENTS
WHERE OWNER='&OWNER' AND SEGMENT_NAME='&TABLE_NAME' AND SEGMENT_TYPE LIKE 'TABLE%'
GROUP BY TABLESPACE_NAME;
2 在建表空间
/** 创建数据表空间***/
create tablespace xx_dat
logging
datafile '/home/oracle/oradata/orcl/xx_dat01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local
查看各表大小:
SELECT SEGMENT_NAME,SUM(BYTES)/1024/1024|| 'M ' 大小 FROM DBA_SEGMENTS
WHERE 1=1
AND OWNER= 'XXXXX' ----XXXXX改成你的owner
AND SEGMENT_TYPE= 'TABLE'
GROUP BY SEGMENT_NAME;