Re: max size tablespace and datafiles

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 Fri Sep 29 2000 - 09:50:03 CDT