1、新添加一个表空间
create smallfile tablespace "TBS4"
datafile
‘/u02/app/oracle/oradata/orcl/tbs401.dbf’ size 10M
reuse autoextend on next 50M,
‘/u02/app/oracle/oradata/orcl/tbs402.dbf’ size 10M
reuse autoextend on next 50M
nologging
default nocompress no inmemory
online
extent management local uniform size 1M
segment space management manual;
2、对现有表空间新添加一个数据文件;
alter tablespace tbs3 add datafile
‘/u02/app/oracle/oradata/orcl/tbs302.dbf’ size 10M;
3、对现有表空间的现有数据库重新定义大小
select file_name,bytes/102