–查询表空间的剩余可用(兆)
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;