/u01/app/oracle/oradata/ocm/tp1.dbf NO
/u01/app/oracle/oradata/ocm/tp2.dbf NO
/u01/app/oracle/oradata/ocm/tp3.dbf NO
（２）把tp3.dbf文件改成自动扩展
sys@OCM> alter database datafile'/u01/app/oracle/oradata/ocm/tp3.dbf'autoextend on next 2M maxsize 2048M;
Database altered.
（３）再次确认tp3.dbf文件是否自动扩展 www.2cto.com
sys@OCM> select file_name,autoextensiblefrom dba_data_files;
FILE_NAME AUT
-----------------------------------------------------
/u01/app/oracle/oradata/ocm/users01.dbf YES
/u01/app/oracle/oradata/ocm/undotbs01.dbf YES
/u01/app/oracle/oradata/ocm/sysaux01.dbf YES
/u01/app/oracle/oradata/ocm/system01.dbf YES
/u01/app/oracle/oradata/ocm/example01.dbf YES
/u01/app/oracle/oradata/ocm/tp1.dbf NO
/u01/app/oracle/oradata/ocm/tp2.dbf NO
/u01/app/oracle/oradata/ocm/tp3.dbf YES