Oracle重置表空间的大小

SQL> select file_id,tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name like 'TEST_T%';

FILE_ID TABLESPACE_NAME FILE_NAME AUTOEX

---------- --------------- ---------------------------------------- ------

b.dbf

SQL> alter database datafile '/home/oracle/oracle/oradata/mdsp/test_tab.dbf' autoextend on next 1 m;

Database altered.

SQL> select file_id,tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name like 'TEST_T%';

FILE_ID TABLESPACE_NAME FILE_NAME AUTOEX

---------- --------------- ---------------------------------------- ------