Thanks they all seem far to large for a realistic datafile but nice to
know..
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message
news:8qpf96$g9pha$1_at_ID-41926.news.cis.dfn.de...
> 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 - 06:00:58 CDT
