- 新建表空間
create tablespace TAB_UD datafile
'/u02/oradata/DB112/TAB_UD_1.dbf' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED,
'/u02/oradata/DB112/TAB_UD_2.dbf' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED
extent management local segment space management auto;
create tablespace I_TAB_UD datafile
'/u02/oradata/DB112/I_TAB_UD_1.dbf' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED,
'/u02/oradata/DB112/I_TAB_UD_2.dbf' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED
extent management local segment space management auto;
2.現有表空間添加文件
alter tablespace TAB_UD add datafile '/u042/oradata/MPDATACENTER/TAB_UD_3.dbf'
size 1G autoextend on next 256M maxsize UNLIMITED;
