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 - 03:44:45 CST
