![](https://csdnimg.cn/release/download_crawler_static/86970959/bg6.jpg)
How to create it?
创建bigfile tablespace
缺省LOCAL和ASSM管理
对于bigfile普通表空间,只能为LMT+ASSM
对于UNDO,TEMP,SYSTEM可以是LMT+MANUAL
SQL> create bigfile tablespace bigtbs
2 datafile '/data1/oradata/systemfile/bigtbs.dbf' size 50G;
Tablespace created.
SQL> select TABLESPACE_NAME,EXTENT_MANAGEMENT,
SEGMENT_SPACE_MANAGEMENT
2 from dba_tablespaces
3 where tablespace_name='BIGTBS';
TABLESPACE_NAME EXTENT_MAN SEGMEN
------------------------------ ---------- ------
BIGTBS LOCAL AUTO
11/12/2022 oracle教程10管理表空间和数据文件 6