I wouldn't advise files sizes of larger than 4G, indeed I suspect that 2G is
about the largest I'd be happy with.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"George Barbour" <george.barbour_at_gecm.com> wrote in message
news:3a8bbb57$1_at_pull.gecm.com...
> 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 Fri Feb 16 2001 - 10:30:51 CST
