Oracle重置表空间的大小

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

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

         7 TEST_TAB        /home/Oracle/oracle/oradata/mdsp/test_ta   NO

                           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

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

         7 TEST_TAB        /home/oracle/oracle/oradata/mdsp/test_ta    YES