Actually, the maximum size of a Oracle datafile is limited.
normally the datafiles we created is small datafile, we know Oracle supports BIGFILE tablespace, even datafile in BIGFILE tablespace is limited with its size, the normal small datafile will be in smaller size.
And also the size of datafile is related to block size, I remember a BIGFILE can maximally contain (?, 4 or other )G blocks.
Also, In OS layer, the file size is related to filesystem( a section of kernal ), different filesystems can support different maximum file size. also, the file size also related to filesystem block size, with the same filesystem,with 2k block size and 4k block size, are also different .
Talmud
|