Oracle 11g Release 1(11.1)表空间――创建和扩展（永久）表空间(三)
lter database
2 datafile 'd:\oracledata\mytbs01_2.dbf'
3 autoextend on next 1M maxsize 20M;
数据库已更改。
www.2cto.com
SQL> select t.tablespace_name,
2 t.file_name,
3 t.bytes / 1024 / 1024 || 'M' as TOTAL,
4 t.autoextensible,
5 t.maxbytes / 1024 / 1024 || 'M' as MAXSIZE
6 from dba_data_files t
7 where t.tablespace_name = 'MYTBS01';
TABLESPACE_NAM FILE_NAME TOTAL AUTOEXTENSIBLE MAXSIZE
-------------- ---------------------------- ----- --------------- -------
MYTBS01 D:\ORACLEDATA\MYTBS01_1.DBF 2M NO 0M
MYTBS01 D:\ORACLEDATA\MYTBS01_2.DBF 4M YES 20M
作者 IGod接口