一个表空间最多有多少个数据文件和file#与rfile#的关系

是由rowid决定的

create tablespace tools datafile 'd:tools01.dbf' size 1M;ITPUB个人空间t"Fe1o'Sm!dJ0v9p

8na"S |(\`jt7?{)e0declare  
V0v.H2wM"`Z/` R:~_0v_str varchar2(200);
L(mrPO8F*^0beginITPUB个人空间DJD%M-}%hL,t7Y
for i in 2..1024 loop
I"MjR:^aD-td^0v_str:='alter tablespace tools add datafile '||'''D:tools'||i||'.DBF'''||' size 1m';ITPUB个人空间GS)v$T1@3IzZo
execute immediate v_str;ITPUB个人空间+g%h0].{
Lo
end loop;ITPUB个人空间
QU~9^S%e%Q
end;
6cX;` X,{0/ITPUB个人空间]W2^Kc
  
wQ@2Q X~$?![;c1D0
1z2e1zT~y0ORA-01686: max # files (1023) reached for the tablespace TOOLSITPUB个人空间1]Rck'@_&sDS
ORA-06512: at line 7ITPUB个人空间ulI q2^j
ITPUB个人空间N3U)]rh Y]
ITPUB个人空间P SI1y1J8F
SQL> select count(*) from v$datafile where TS#=4;
F$Gu!UV6D&yk0
fs})|f5|R0
S~ ^3S T{,tt0  COUNT(*)
K|~ A!nV0----------ITPUB个人空间ZDKw|0I
      1023
xM6N2Es0
-P_LLM['K0SQL>ITPUB个人空间zQ~g3GK`
ITPUB个人空间r,_m3qhWJ,fQ7x

file#与rfile#的关系

rfile#相对数据文件号的值只能由1到1023    oracle rowid 10bit rfile#

file# 数据文件号一直往上递增的,整个数据库大概可以达到65533个文件

SQL> select file#,rfile#,name,ts# from v$datafile where TS#=4 or TS#=8;ITPUB个人空间,yJ&Q
WZ B#D eR
 
R'uv!i;q~*t,N0     FILE#     RFILE# NAME                                                                                    TS#
y)W-nU-mb0---------- ---------- -------------------------------------------------------------------------------- ----------
dM6vD!j$J0         4          4 D:\TOOLS01.DBF                                                                            4
o9Q3m%km+x"wF0         6          6 D:\TOOLS2.DBF                                                                             4
Wc-j2?d$Rx7N0         7          7 D:\TOOLS3.DBF                                                                             4ITPUB个人空间"gE8fM$H
         8          8 D:\TOOLS4.DBF                                                                             4
:U6O Hh"qWQ{|0         9          9 D:\TOOLS5.DBF                                                                             4ITPUB个人空间m{9Q r"k,V`9Vh
        10         10 D:\TOOLS6.DBF                                                                             4ITPUB个人空间"X,`"\"z#Sd{r
        11         11 D:\TOOLS7.DBF                                                                             4ITPUB个人空间!o`W1R2ldZ
        12         12 D:\TOOLS8.DBF                                                                             4
Z H?;E `Z0        13         13 D:\TOOLS9.DBF                                                                             4ITPUB个人空间X1R#Hv8yA9O
        14         14 D:\TOOLS10.DBF                                                                            4
g%G oV/eK F0        15         15 D:\TOOLS11.DBF                                                                            4
q{k8P|#]9Rc0        16         16 D:\TOOLS12.DBF                                                                            4
:tK,XCx4|x0        17         17 D:\TOOLS13.DBF                                                                            4ITPUB个人空间 [2Y#C?i$| \
        18         18 D:\TOOLS14.DBF                                                                            4ITPUB个人空间?N,DH5ik-_ E&c
        19         19 D:\TOOLS15.DBF                                                                            4ITPUB个人空间N8{'nhw&A9k
        20         20 D:\TOOLS16.DBF                                                                            4
"H#v$ak)R,@Uo0        21         21 D:\TOOLS17.DBF                                                                            4
8U3n7^5~"`%rPci]0        22         22 D:\TOOLS18.DBF                                                                            4ITPUB个人空间Fiqdo;E? \
        23         23 D:\TOOLS19.DBF                                                                            4
"vR^1Q\%[V2m"X0        24         24 D:\TOOLS20.DBF                                                                            4ITPUB个人空间)d9@:T8C-[Z
 ITPUB个人空间OR/c*R\z^3|k9w.L
     FILE#     RFILE# NAME                                                                                    TS#ITPUB个人空间(~n{$|"U"V
---------- ---------- -------------------------------------------------------------------------------- 
Q
Q4?^5W$b0       104        104 D:\TOOLS100.DBF                                                                           4ITPUB个人空间r&K T6c;yt
       105        105 D:\TOOLS101.DBF                                                                           4ITPUB个人空间Dga MB$x0W
       106        106 D:\TOOLS102.DBF                                                                           4ITPUB个人空间5q4O-I8IgvV
       107        107 D:\TOOLS103.DBF                                                                           4
2WY
?\g7^;o(vkW0       108        108 D:\TOOLS104.DBF                                                                           4ITPUB个人空间(G;tY"BhP
...........................

      1021       1021 D:\TOOLS1017.DBF                                                                          4
4x6Wf,Mb t0      1022       1022 D:\TOOLS1018.DBF                                                                          4
Zn,i2E1Vjr*s0      1023       1023 D:\TOOLS1019.DBF                                                                          4
+v9Jj+|!y s^0      1024          1 D:\TOOLS1020.DBF                                                                          4
S2H4\GRz0      1025          2 D:\TOOLS1021.DBF                                                                          4ITPUB个人空间9^5L6z:Z,gdyK4W)E
      1026          3 D:\TOOLS1022.DBF                                                                          4ITPUB个人空间`d2e!Zk/~t
      1027          5 D:\TOOLS1023.DBF                                                                          4
$I7A8{g5F5r-W0      1028          5 D:\PAULS01.DBF                                                                            8
"k-W?k&c7DZ9hM0      1029          6 D:\PAULS2.DBF                                                                             8ITPUB个人空间%s[IZ4GcM9R`
      1030          7 D:\PAULS3.DBF                                                                             8
E
|%k|zC0kt0      1031          8 D:\PAULS4.DBF                                                                             8
Ccjy[8G9HYyG0      1032          9 D:\PAULS5.DBF                                                                             8
k
tS0cf`WV0 ITPUB个人空间2Qz
Y]'_5\"G"\|
     FILE#     RFILE# NAME                                                                                    TS#ITPUB个人空间#]xN,P8g
---------- ---------- -------------------------------------------------------------------------------- ----------
@
sI[*w$rhv!t P
i0      1033         10 D:\PAULS6.DBF                                                                             8ITPUB个人空间
k)O;U!kk6O,N c~
      1034         11 D:\PAULS7.DBF                                                                             8ITPUB个人空间4N
lij(};cJ4bw
      1035         12 D:\PAULS8.DBF                                                                             8ITPUB个人空间3FE"DdQvz
      1036         13 D:\PAULS9.DBF                                                                             8
,t/E+G9_W]?5g0      1037         14 D:\PAULS10.DBF                                                                          8

可以看到rfile#的值由1-1023之间 并且对应一个表空间

file#的值一直是递增的 相当于序列号 对应整个数据库

SQL> alter system set db_files=100000 scope=spfile;

System altered.

SQL> shutdown immediate;
a3Ti0yvo1i#_0Database closed.ITPUB个人空间3{sVe,R*}FaX2T
Database dismounted.ITPUB个人空间h
gfAOS$r
ORACLE instance shut down.ITPUB个人空间,t0~%]!?uq:I
SQL> startup
)C}ht0_gz'\,s0ORA-01131: DB_FILES system parameter value 100000 exceeds limit of 65534

可以看到数据文件最多为65533