Re: 2 GB file size limit

From: Jeroen <jeroen.vdgoorbergh_at_lostboys.nl>
Date: Fri, 2 Mar 2001 12:50:03 +0100
Message-ID: <97o1e4$h6$1@news1.xs4all.nl>

I encountered the 4 Gb problem with Oracle on NT a year ago. The way I 'solved' it is to partition the table, which caused the problem, into smaller partitions.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:97if4p$sfu$1_at_soap.pipex.net...
> What is the problem exactly? Windows NT4 emphatically does not have a 2GB
> file size limit. There is however a bug with oracle on NT which leads to
the
> recommendation that datafiles should never be larger than 4GB the metalink
> reference was posted here within the last week or so). I can't speak for
> Solaris.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Madhav Agrawal" <madhavagrawal_at_home.com> wrote in message
> news:ol1n6.36404$5M5.1933068_at_news1.frmt1.sfba.home.com...
> > Hi guys,
> >
> > Can anyone tell me how to overcome with the OS 2 GB file size limit. we
are
> > working on Windows NT,Sun Solaris.
> >
> >
> > Thanks in advance.
> >
> > Madhav
> >
> >
>
>
Received on Fri Mar 02 2001 - 05:50:03 CST