Re: max size tablespace and datafiles

Thanks a lot.

Reinier.

Steitz Adolf <adolf.steitz_at_also.de> wrote in message news:39d4aca4$0$4870_at_businessnews.de.uu.net...
> Hi,
>
> there is no problem to have a tablespace of over 10 GB.
> Also i know an installation with a datafile size of 30 GB.
>
> But, I tried to create a datafile with 15 GB (Oracle 8.0.5 on NT) and it
> failed.
> Oracle Hotline told me, with 8.0.5 there are problems to create such a big
> datafile.
> With your version, it should work.
>
> But, Oracle recommend a maximum size of 4 GB for datafiles.
> In case of failure the recovery is faster.
>
> Now, i have a tablespace with 14 GB and 4 * 4GB datafiles.
> And there are also BLOBS stored.
>
> Adolf
>
>
> Reinier <Reinier_Dickhout_at_hetnet.nl> schrieb in im Newsbeitrag:
> uoWEg9fKAHA.100_at_net003s...
> > Hello,
> >
> > I've browsed through the 8.1.5 server documentation but couldn't find
 the
> > info I needed...
> > We're running a 8.1.5 database on WindowsNT . I think I read somewhere
 that
> > the maximum size of datafiles is 2 GB. Could someone verify that, and
 maybe
> > direct me to some documentation on that subject?
> > Also could anyone tell me about any size-limitations on tablespaces,
 will
> > there be a problem with a tablespace of over 10 GB if it has multiple
 (2GB
> > sized) datafiles? Is there a maximum?
> > One more thing, we want to store blobs, does that have any consequences
 at
> > all?
> >
> > TIA,
> >
> > Reinier.
> >
> >
> >
>
>
Received on Mon Oct 02 2000 - 01:36:31 CDT