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