From: mpir@bellsouth.net (Joe Maloney) Newsgroups: comp.databases.oracle.server Subject: Re: File size 2GB limit Date: 8 Aug 2001 12:57:04 -0700 Organization: http://groups.google.com/ Lines: 37 Message-ID: References: NNTP-Posting-Host: 199.15.61.5 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 997300625 4778 127.0.0.1 (8 Aug 2001 19:57:05 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2001 19:57:05 GMT 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" wrote in message news:... > 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" wrote in message > news:I01c7.32490$jA2.2316794@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 > > > > > > > >