Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: 4G Limit of Data File Size in Windows NT4
Niall,
I found a patch 8.0.5.2.6, which can be applied to 8.0.5.0.0. File size 64G is the limit, but 15G has been tested, according to the document.
Regards,
Dino
Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:8qnch9$n8l$1_at_soap.pipex.net...
> "Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message
> news:8qerjt$fdcl2$1_at_ID-41926.news.cis.dfn.de...
> > Dear all,
> >
> > We have recently encountered 3 times tablespace crashes, for which we
have
> > to drop and re-create the tablespace. According to the alert log, Oracle
> > support people told me this problem is due to a data file extended to
more
> > than 4G size, which is the limit of file sizes in Windows NT4. However,
our
> > data file may extend to more than 10G in size, so what is the
appropriate
> > way to define the sizes of tablespaces and data files?
> >
> > Thanks,
> > Dino
>
> Hi.
>
> I see others have advised you to use more and smaller datafiles which
seems
> like good advice. I'd be interested to see any tech support notes that you
> might have got from Oracle though, as IIRC, under NT4 files can grow to
some
> riduculously huge size well in excess of 4GB. So is the 4gb an OS limit or
> an Oracle limit?
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Tue Sep 26 2000 - 01:21:21 CDT