创办表空间

创建表空间

1、创建表空间（创建一个表空间对应三个数据文件）

SQL>create tablespace ts_dongloggingdatafile '/opt/orcl_11g/oradata/dong/dong01.dbf'size 200mautoextend onnext 100m maxsize UNLIMITED , '/opt/orcl_11g/oradata/dong/dong02.dbf'size 200m autoextend onnext 100m maxsize UNLIMITED , '/opt/orcl_11g/oradata/dong/dong03.dbf'size 200m autoextend onnext 100m maxsize UNLIMITED extent management local;

2、追加表空间数据文件

?

SQL>alter database datafile '/opt/orcl_11g/oradata/dong/dong04.dbf' size 200m autoextend onnext 100m maxsize UNLIMITED  ;

3、查看所有表空间及对应数据文件

?

SQL>select file_name, tablespace_name from dba_data_files;

?