使用resize来修改表数据文件的大小
alter database datafile 'xxx' resize xxxM
实验
修改/u01/oradata/houzhh/myts02.dbf打打小到200M
SQL> select file_name,tablespace_name as tname,bytes from dba_data_files;
FILE_NAME TNAME BYTES
------------------------------ ------------------------------ ----------
/u01/oradata/houzhh/myts01.dbf MYTABLESPACE 104857600
/u01/oradata/houzhh/myts02.dbf MYTABLESPACE 104857600
SQL> alter database datafile '/u01/oradata/houzhh/myts02.dbf' resize 200M;
Database altered.
SQL> select file_name,tablespace_name as tname,bytes from dba_data_files;
FILE_NAME TNAME BYTES
------------------------------ ------------------------------ ----------
/u01/oradata/houzhh/myts01.dbf MYTABLESPACE 104857600
/u01/oradata/houzhh/myts02.dbf MYTABLESPACE 209715200