Re: Recovery Question

On Jul 23, 2:32 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 32-bit operating systems can access no more than 4 GB of memory,
> period, and as such usually inflict a file size restriction of 2 GB;
> this puts your 7 GB file 'out of the ball park' as far as
> accessibility and 'recognizability' to the software.

The memory section is sort of true, though it oversimplifies somewhat as people using 32bit linux servers with > 4gb ram can testify. The file size assertion is just wrong. NTFS file sizes are limited to 2^^44 (-64k) bytes. (http://www.microsoft.com/technet/prodtechnol/ windows2000serv/reskit/core/fncc_fil_tvjq.mspx?mfr=true) though in fact, depending on oracle database version datafile size may be more limited than that. In fact you'll see that back in the 8i/NT4 days 11gb was just fine (http://tinyurl.com/3x2zhz) it was 4gb that was a problem :(. I believe certain *nix filesystems were limited to 2gb in those days.

Niall Litchfield
Oracle DBA Received on Mon Jul 23 2007 - 09:01:13 CDT