Re: File size 2GB limit

Although academically in 8.0.5.x there is no file size limit, there actually are two.

The first is a data dictionary bug that can (but not necessarily will) cause corruption for files larger than 4G. It is fixed later, but play it safe.

THere is also a 2g file size limit wired into Imp/Exp that is supposed to be changed/upped in the later releases, but I haven't done that yet.

"balaski" <balaski_at_snet.net> wrote in message news:<XU1c7.3141$TI6.1964155_at_typhoon.snet.net>...
> Hi --
>
> Generally it is still not recommended -- See oracle Note
> Note:112011.1
> Subject: ALERT: RESIZE or AUTOEXTEND can "Over-size" Datafiles and
> Corrupt the Dictionary
> Last Revision Date: 09-MAR-2001
> *** This alert was updated on 09-Mar-2001 to add details of Bug:1646512
>
>
>
>
>
> "Zhenming Wang" <zmwang_at_sympatico.ca> wrote in message
> news:I01c7.32490$jA2.2316794_at_news20.bellglobal.com...
> > I wonder whether NT4.0 NTFS file system supports large file size (>2GB)
> > when Oracle server installed on it. Is it NT 32-bit restriction or
 Oracle's
> > restriction? Which Oracle version is a 64-bit?
> >
> > Zhenming
> >
> >
> >
> >
Received on Wed Aug 08 2001 - 14:57:04 CDT