测试一个表空间最多可以创建多少个文件

create tablespace tools datafile 'd:tools01.dbf' size 1M;

declare  
v_str varchar2(200);
begin
for i in 2..1024 loop
v_str:='alter tablespace tools add datafile '||'''D:tools'||i||'.DBF'''||' size 1m';
execute immediate v_str;
end loop;
end;
/
  

ORA-01686: max # files (1023) reached for the tablespace TOOLS
ORA-06512: at line 7


SQL> select count(*) from v$datafile where TS#=4;


  COUNT(*)
----------
      1023

SQL> 

 

from itpub http://www.itpub.net/viewthread.php?tid=964023