alter database datafile 'datafile_name' autoextend on next 100M maxsize 2000M;
如果單個datafile可能&可以超過2G,也可以設max size unlimited,不然只好根據粗略估計,給可能超過2G的tablespace預分配幾個datafile
alter tablespace tablespace_name add datafile 'datafile_name_2'
size 100M autoextend on next 100M maxsize 2000M;
增長量next請視情況而定
如果之後想停止datafile的自動增長,使用autoextend off子句即可.
alter database datafile 'datafile_name' resize 200M;
If there are database objects stored above the specified size, then the data file size is
decreased only to the last block of the last objects in the data file.