Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large files under oracle7.1.6
maurice segers wrote:
>
> Hi there,
>
> We are installing a large database on a HPUX 10.20 machine usinf oracle
> 7.1.6.
> There are several tables that are very large (one table over 28 GB). After
> checking oracle if they are supporting large file (over 2GB) the answer was
> no.
>
> One solution is to split the datafiles into 2GB of space. But as you know
> you cannot make you tables larger than the datafile.
Not correct,
you can not have an extent greater than a datafile, but you CAN HAVE a
table
(or tablepsace) greater than a datafile due the fact that a table
contains
one or more extents and each extent might be 2GB (or a tablespace
contains
one or more datafile).
>
> Does anyone use HPUX 10.20 whit tablespaces larger than 2GB at once and
> what is your experiance.
>
I worked with HP 10.10 and tablespaces > 50GB . The "problem" we had was
with
backup/restore, due to slow media devices and short backup/restore
windows.
rgds
eugen
Received on Mon Feb 23 1998 - 00:00:00 CST