oracle的表空间扩容

–查询表空间的剩余可用(兆)

select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;  

–查询表空间的存储地址

select t.* from dba_data_files t where tablespace_name=upper('test');

–增加表空间 20G，每次自增长200M

alter tablespace test add datafile '/data/dbf/orcl/test6.dbf' size 20g autoextend on next 200m;

–新建表空间 20G，每次自增长200M

create tablespace test datafile '/data/dbf/orcl/test6.dbf' size 20g autoextend on next 200m;