最好是设置为数据文件已满后自动扩充,以免遇到文件不足时,不能正常使用表空间的问题 :----> It is not a good idea ( Unless you are a lazy DBA :-) there are 2 way to resize the tablespace : 1. change the size of datafile alter database datafile '<file>' resize 100 M; 2. add new datafile alter tablespace tsname ADD DATAFILE '<file>' SIZE 100M ;
1. change the size of datafile
alter database datafile '<file>' resize 100 M;
2. add new datafile
alter tablespace tsname ADD DATAFILE '<file>' SIZE 100M ;