oracle-datafile管理

数据文件，这一节还是比较简单的，都是一些简单的操作实验。

A physical operating system file on disk that was created by Oracle and contains data structures such as tables and indexes. A datafile can only belong to one database.

一、给表空间添加数据文件

1、新建一个表空间

SQL> create tablespace testdb datafile '/u01/app/oracle/oradata/db/testdb01.dbf' size 10M;   

Tablespace created.

2、新建一个临时表空间

SQL> create temporary tablespace tempts2 tempfile '/u01/app/oracle/oradata/db/tempts2.dbf' size 10M;

Tablespace created.

3、添加一个数据文件

SQL> alter tablespace testdb add datafile '/u01/app/oracle/oradata/db/testdb02.dbf' size 10M;

Tablespace altered.

4、添加一个临时表空间数据文件

SQL> alter tablespace tempts2 add tempfile '/u01/app/oracle/oradata/db/tempts201.dbf' size 10M;

Tablespace altered.

二、改变数据文件大小

1、打开或关闭数据文件的自动扩展

SQL> select file_id,file_name,autoextensible from dba_data_files;

   FILE_ID FILE_NAME                                          AUT
---------- -------------------------------------------------- ---
         1 /u01/app/oracle/oradata/db/system01.dbf            NO
         2 /u01/app/oracle/oradata/db/sysaux01.dbf            NO
         3 /u01/app/oracle/oradata/db/undotbs01.dbf           NO
         4 /u01/app/oracle/oradata/db/users01.dbf             NO
         5 /u01/app/oracle/oradata/db/testdb01.dbf            NO
         6 /u01/app/oracle/oradata/db/testdb02.dbf            NO

6 rows selected.
-->开启数据文件的自动扩展
SQL> alter database datafile 5 autoextend on;    

Database altered.

SQL> alter database datafile 6 autoextend on next 512M maxsize 1G;

Database altered.

SQL> select file_id,file_name,autoextens