创建表空间:
create tablespace tbs1 datafile '/dm7/data/DAMENG/tbs_01.dbf' size 32; //表空间要偶数,单位M 注意路径dm7
create tablespace tbs2 datafile '/dm7/data/DAMENG/tbs2_01.dbf' size 50 autoextend on maxsize 100; //初始50M,最大100M
create tablespace tbs4 datafile '/dm7/data/DAMENG/tbs4_01.dbf' size 50 autoextend on next 1 maxsize 100; //初始50M,以1M为单位拓展,最大100M
create tablespace tbs4 datafile '/dm7/data/DAMENG/tbs4_01.dbf' size 50 autoextend on next 1 maxsize 100, '/dm7/data/DAMENG/tbs4_02.dbf' size 50 autoextent on next 1 maxsize 100;//建立多个表空间,分为两个数据文件,共200M
alter tablespace tbs2 addd datafile '/dm7/data/DAMENG/tbs2_02.dbf' size 50 autoextend on maxsize 100; //修改表空间文件数
alter tablespace tbs1 offline;//修改表空间为offline/online;
sele