新建表空间

```
create tablespace NNC_DATA01 logging datafile 'F:\Oracle\app\lizx\product\11.2.0\oradata\ncdata\nnc_data01.dbf' size 2048M autoextend on next 1024M maxsize unlimited extent management local segment space management auto;

CREATE TABLESPACE NNC_DATA01 DATAFILE 'F:\Oracle\app\lizx\product\11.2.0\oradata\ncdata\nnc_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE NNC_DATA02 DATAFILE 'F:\Oracle\app\lizx\product\11.2.0\oradata\ncdata\nnc_data02.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

CREATE TABLESPACE NNC_DATA03 DATAFILE 'F:\Oracle\app\lizx\product\11.2.0\oradata\ncdata\nnc_data03.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;

CREATE TABLESPACE NNC_INDEX01 DATAFILE 'F:\Oracle\app\lizx\product\11.2.0\oradata\ncdata\nnc_index01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE TABLESPACE NNC_INDEX02 DATAFILE 'F:\Oracle\app\lizx\product\11.2.0\oradata\ncdata\nnc_index02.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;

CREATE TABLESPACE NNC_INDEX03 DATAFILE 'F:\Oracle\app\lizx\product\11.2.0\oradata\ncdata\nnc_index03.dbf' SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
```

如果想建一个大的表空间

```
create bigfile tablespace NNC_DATA01 logging datafile 'C:\data\nnc_data01.dbf' size 200G autoextend on next 1G maxsize unlimited extent management local segment space management auto;

CREATE bigfile TABLESPACE NNC_DATA01 DATAFILE 'C:\data\nnc_data01.dbf' SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
```

![1698383061714.jpg](http://mydev.wang/usr/uploads/2023/11/3344677372.jpg)

最后修改：2023 年 11 月 04 日