Re: Large files under oracle7.1.6

From: <ketanindia_at_hotmail.com>
Date: 1998/02/25
Message-ID: <6d1ts8$op4$1@nnrp1.dejanews.com>#1/1

Hi Maurice,
U can create tablespaces of any size by adding the additional files. i.e. u can have a 4 GB tablespace by having 4 files of 1GB each.

Also u can have striped tablespace with each stripe corresponds to a file.

I suggest u refer the Oracle7 server administrator's guide - and chapter 22 in it.

Ketan Shah

In article <01bd403d$9a2153a0$118df1c3_at_msegers>, "maurice segers" <msegers_at_worldonline.nl> 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.
>
> Does anyone use HPUX 10.20 whit tablespaces larger than 2GB at once and
> what is your experiance.
>
> Mauice
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Feb 25 1998 - 00:00:00 CST