SQL> alter database datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TEST.DBF' AU
TOEXTEND ON NEXT 100M MAXSIZE 4g;
数据库已更改。
SQL> select file_name,autoextensible,increment_by from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
AUT INCREMENT_BY
--- ------------
E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\USERS01.DBF
YES
160
E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSAUX01.DBF
YES 1280
E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\UNDOTBS01.DBF
YES
640
SQL> alter database datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\TEST.DBF' AU
TOEXTEND ON NEXT 100M MAXSIZE 4g;
数据库已更改。
SQL> select file_name,autoextensible,increment_by from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
AUT INCREMENT_BY
--- ------------
E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\USERS01.DBF
YES
160
E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSAUX01.DBF
YES 1280
E:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\UNDOTBS01.DBF
YES
640