-
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?
David Knight
OCP DBA 8i, 9i, 10g
-
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.
--------------------------
The Time has come ....
-
Are there any special parameter settings needed in Oracle to enable datafiles greater than 2 GB?
With NTFS, the datafile size limit is based on the value of DB_BLOCK_SIZE.
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]
I would never have a file grow more than 1G.
Neither would I. Fortunately, I can blame it on someone else. :-)
After the Unix SA enabled largefiles, everything is fine.
David Knight
OCP DBA 8i, 9i, 10g
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|