1、确认磁盘空间足够,增加一个数据文件
alter tablespace MLOG_NORM_SPACE
add datafile '/oracle/oms/oradata/mlog/Mlog_Norm_data001.dbf'
size 10M autoextend on maxsize 20G
2、验证已经增加的数据文件
select file_name,file_id,tablespace_name from dba_data_files
where tablespace_name='MLOG_NORM_SPACE'
3、如果删除表空间数据文件
alter tablespace MLOG_NORM_SPACE
drop datafile '/oracle/oms/oradata/mlog/Mlog_Norm_data001.dbf'
4、扩大表空间(后面的10240m值一定要比现在的大)
alter database datafile '/opt/oracle/oradata/bms/ECD' resize 10240m;
5、查询表占用空间
select segment_name, sum(bytes)/1024/1024 Mbytese from user_segments group by segment_name
快速删除
truncate table KUAIDIDATA