--取消数据文件的自动扩展
SQL> alter database datafile '/opt/bboss/tst4/oracle/arch/zx1.dbf' autoextend off;
Database altered.
SQL> select file_name,tablespace_name,bytes,maxbytes,bytes-maxbytes,autoextensible from dba_data_files where tablespace_name='ZX1';
FILE_NAME TABLESPACE_NAME BYTES MAXBYTES BYTES-MAXBYTES AUT
---------------------------------------------------------------------------------------------------- ------------------------------ -------------------- -------------------- -------------------- ---
/opt/bboss/tst4/oracle/arch/zx1.dbf ZX1 34359730176 0 34359730176 NO
--可以看到MAXBYTES变为了0
如果再把数据文件改为可自动扩展又会出现什么情况呢