设置maxsize的自动扩展数据文件在达到maxsize后是否会继续扩展

创建测试表空间：create tablespace tmaxs datafile 'D:\APP\LIMING\ORADATA\ORCL11S\tmaxs01.DBF' size 1M autoextend on maxsize 1M;查看表空间信息：SQL> select d.file_name,d.tablespace_name,d.maxbytes,d.autoextensible from dba_data_files d where d.tablespace_name='TMAXS'; FILE_NAME                                                                        TABLESPACE_NAME                  MAXBYTES AUTOEXTENSIBLE-------------------------------------------------------------------------------- ------------------------------ ---------- --------------D:\APP\LIMING\ORADATA\ORCL11S\TMAXS01.DBF                                        TMAXS                             1048576 YES 在表空间中创建表：create table tmaxs(id char(100),name char(1000)) tablespace tmaxs;插入数据：begin   for i in 1..1000 loop     insert into tmaxs values(i,i||'test');   end loop;   commit;end;循环几次后：SQL> begin  2     for i in 1..1000 loop  3       insert into tmaxs values(i,i||'test');  4     end loop;  5     commit;  6  end;  7  / begin   for i in 1..1000 loop     insert into tmaxs values(i,i||'test');   end loop;   commit;end; ORA-01653: 表 LM.TMAXS 无法通过 8 (在表空间 TMAXS 中) 扩展ORA-06512: 在 line 4检查：SQL> select d.file_name,d.tablespace_name,d.maxbytes,d.autoextensible,d.bytes from dba_data_files d where d.tablespace_name='TMAXS'; FILE_NAME                                                                        TABLESPACE_NAME                  MAXBYTES AUTOEXTENSIBLE      BYTES-------------------------------------------------------------------------------- ------------------------------ ---------- -------------- ----------D:\APP\LIMING\ORADATA\ORCL11S\TMAXS01.DBF                                        TMAXS                             1048576 YES               1048576那么：设置maxsize的自动扩展数据文件在达到maxsize后不会继续扩展。