Oracle中创建表空间实例

创建一个大表空间，大小1g
sys@ORCL 19:23:38> create bigfile tablespace big_tbs datafile '/oradata/orcl/disk1/big_tbs.dbf'size 1g;

Tablespace created.
创建一个index01表空间，每个区大小1m
sys@ORCL 19:30:12> create tablespace index01 datafile '/oradata/orcl/disk1/index01.dbf' size 10m uniform size 1m;

Tablespace created.

sys@ORCL 19:41:05> create tablespace data_tbs datafile '/oradata/orcl/disk1/data_tbs.dbf' size 10m default storage(initial 512K next 512K);

Tablespace created.

sys@ORCL 19:50:36> drop tablespace data_tbs including contents and datafiles;

Tablespace dropped.

sys@ORCL 19:52:39> create tablespace data_tbs datafile '/oradata/orcl/disk1/data_tbs.dbf' size 10m default storage(initial 512K next 512K) maxsize unlimited extent management local;
create tablespace data_tbs datafile '/oradata/orcl/disk1/data_tbs.dbf' size 10m default storage(initial 512K next 512K) maxsize unlimited extent management local
                                                                                                                        *
ERROR at line 1:
ORA-02180: invalid option for CREATE TABLESPACE


sys@ORCL 19:55:21> create tablespace data_tbs datafile '/oradata/orcl/disk1/data_tbs.dbf' size 10m maxsize unlimited default storage(initial 512K next 512K);
create tablespace data_tbs datafile '/oradata/orcl/disk1/data_tbs.dbf' size 10m maxsize unlimited default storage(initial 512K next 512K)
                                                                                *
ERROR at line 1:
ORA-02180: invalid option for CREATE TABLESPACE

创建一个data表空间，下一个区512K，大小无限制
sys@ORCL 19:56:11> create tablespace data_tbs datafile '/oradata/orcl/disk1/data_tbs.dbf' size 10m autoextend on  maxsize unlimited default storage(initial 512K next 512K);

Tablespace created.
创建一个prod表空间，自动增长，使用ASSM技术
sys@ORCL 19:57:13> create tablespace prod_tbs datafile '/oradata/orcl/disk1/prod_tbs.dbf' size 10m autoextend on next 1m segment space management auto;

Tablespace created.