Re: OS File size limitations

From: <rspeaker_at_my-deja.com>
Date: Wed, 03 Nov 1999 14:57:41 GMT
Message-ID: <7vpih2$u5c$1@nnrp1.deja.com>

In a nutshell, Oracle doesn't care if a 3-GB tablespace is made up of (1) 3-GB file or (3) 1-GB files. If you are limited by the OS to a specific max file size, build your tablespace using multiple smaller datafiles striped across multiple disks for best performance.

HTH,
Roy

In article <7vpe61$bj6$1_at_lure.pipex.net>, "Dave" <none_at_nowhere.nothere.oops> wrote:
> How does Oracle deal with large tables?
> I am an Oracle novice and am curious about how
> large tables work. I have a large set of flat files
> about 13 of them containing names and addresses
> etc, nice simple data but lots of it. The 13 files
> average about 1.8GB each. Solaris 2.5.1 has
> a file size max of 2.0GB. How does Oracle deal
> with this volume of data? I have a large amout
> of disk space available 16*9GB SCSI disks. I
> am assuming that all data loaded into a table
> can be spread evenly over all the disks. As I
> mentioned I am a novice, am I jumping the gun
> a bit here, should I read more docs first before
> I attempting this sort of thing.
>
> Dave
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 03 1999 - 08:57:41 CST