Re: 4GB file limit in Oracle8 ???

Caution!
I suppose it comes down to what you test after you have created large files. Oracle themselves, advise file sizes of less that 4Gig on NT. Check out the Note:67421.1on Metalink
George Barbour.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:96g8ej$s1d$1_at_soap.pipex.net...
> There is no 4GB file size limit in NT when using NTFS this I know for sure
> because we once had a 5.5GB temp tablespace datafile (oops). If the disk
> were a FAT partition is could only reach 4GB. I cannot speak for Oracle
> 8.0.5 (not running it), but 8i certainly will handle files larger than 4
> gig. So I suspect that the autoextend clause is autoextend on maxsize
 4GB.
> This can be checked for in OEM (or DBA studio or whatever graphical tool
> comes with 8.0.5).
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Mustapha Nuvvercrap" <hashman_at_bigpond.net.au> wrote in message
> news:2_Li6.25675$o85.123745_at_news-server.bigpond.net.au...
> > I believe the limit may lie within NT and the cluster size of the NTFS
> > partition. I believe the 4GB limit may be imposed by the 512 byte
 cluster
> > size of the partition.
> >
> > At least AFAICR...
> >
> > "Jaroslaw Lubczynski" <eljot_at_elkomtech.com.pl> wrote in message
> > news:96g10l$ps7$1_at_news.tpi.pl...
> > > Is there any 4GB file limit in Oracle8 ???
> > >
> > > Situation:
> > > Oracle 8.0.5 Workgroup Edition on Win NT 4.0 (Intel, RAID V
 controller),
> > > Service Pack 6, NTFS. Tablespace USER consists of one large 4 GB file
 with
> > > Auto Extend flag enabled. When tablespace was fulfilled and INSERTs
> > > coutinued, Oracle would try to extend file over 4GB size I suppose.
 Then
> > > database crashed. error ORA-00600 occured (internal error) and
 datafile
 of
> > > tablespace USER was truncated to about 8 MB in size. Of course I had
 to
> > > restore database from tape.When I restarted application which made
 several
> > > INSERTs into database, Oracle crashed again when tablespace USER got
> > > fulfilled.
> > >
> > > Now the tablespace USER has been divided into several smaller ( <=
 2GB )
> > > files and works perfectly, so questions are:
> > > 1. Is there a 4 GB datbase file limit in Oracle8 (or Win NT?????), or
> > > 2. Is any known bug in Oracle8 which can cause crash after trying to
> > > increase database file over 4GB?
> > >
> > > I have found no word about it in my CD docs.
> > >
> > > I hope there is no reachable limit in tablespace size (I will be
 forced
 to
> > > add 3rd 2GB datafile to largest tablespace very soon).
> > >
> > > thanks for any information,
> > >
> > > Jaroslaw ELJOT Lubczynski
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Thu Feb 15 2001 - 05:26:22 CST