Printable View
The platform is Solaris 2.8 and Oracle 8.1.7.1.
While copying from 8.1.5 to what will be the file system for an 8.1.7 instance, a 2.6 GB datafile ran into the size limit. The friendly Unix SA explained that this can be cured with a largefiles setting an some small changes on Veritas.
Are there any special parameter settings needed in Oracle to enable datafiles greater than 2 GB?
On UNIX, block sizes usually vary between 2-8K, although larger than 8K is
possible. Maximum database file size is 2Gb on most 32-bit UNIX platforms,
though some (AIX, Solaris and HP/UX) now support a larger maximum, usually 32Gb.
With NTFS, the datafile size limit is based on the value of DB_BLOCK_SIZE.Quote:
Are there any special parameter settings needed in Oracle to enable datafiles greater than 2 GB?
Examples:
2k block size max= 8GB
4k block size max= 16GB
8k block size max= 32GB
16k block size max= 64GB
The maximum file size for FAT is 4GB.
I would never have a file grow more than 1G.
[QUOTE]Originally posted by julian
[B]Neither would I. Fortunately, I can blame it on someone else. :-)Quote:
I would never have a file grow more than 1G.
After the Unix SA enabled largefiles, everything is fine.