Oracle表空间扩容

报错异常：ORA-01653:表**无法通过1024（在表空间*中）扩展

#查询表空间文件大小
SELECT tablespace_name,file_id,  file_name,  round(bytes / (1024 * 1024), 0) total_space FROM dba_data_files ORDER BY tablespace_name;

 

#查询表空间使用率

SELECT a.tablespace_name,
a.bytes total,
b.bytes used,
c.bytes free,
(b.bytes * 100) / a.bytes "% USED ",
(c.bytes * 100) / a.bytes "% FREE "
FROM sys.sm$ts_avail a, sys.sm$ts_used b, sys.sm$ts_free c
WHERE a.tablespace_name = b.tablespace_name
AND a.tablespace_name = c.tablespace_name;

 

#修改表空间大小,扩容
alter database datafile '/oradata/TBS_TABLEQUERY.dbf' resize 30000m

 

#设置表空间自动递增，最大30000m
alter database datafile '/oradata/TBS_TABLEQUERY.dbf' autoextend on next 100m maxsize 30000m