①创建表空间
CREATE TABLESPACE tbs_02
DATAFILE 'diskb:tbs_f5.dat' SIZE 100M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M;
②修改表空间
alter database datafile '/vol01/app/oracle/oradata/rms/sysaux01.dbf' autoextend on next 100M maxsize 3000M;
③添加表空间文件
alter tablespace SYSAUX add datafile '/vol01/app/oracle/oradata/rms/sysaux02.dbf'
size 100M autoextend on next 10M maxsize 2000M;