Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data file size limit
"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<bae_8.102945$6r.3485315_at_news4.srv.hcvlny.cv.net>...
> 32 bit Oracle has 2G limitations .....
> 64 bit Oracle can handle bigger file sizes ...
>
> Anurag
No, 32 bit Oracle can handle files > 2 GB just fine.
Oracle has only one internal limit - a file cannot have more than 4,000,000
blocks (or near it). So for 8K blocks you can have 32 GB files.
All "tuning" has to be done on OS side, nothing on Oracle side:
1. Check ulimit
2. Try to create a file > 2B manually (using mkfile, for example)
Received on Sun Jul 21 2002 - 06:37:20 CDT