Re: OS File size limitations

From: bgbgbg <brian.gallagher_at_iona.com>
Date: Wed, 3 Nov 1999 16:53:01 -0000
Message-ID: <7vppbl$f7j$1@bvweb.dublin.iona.ie>

Oracle can easily store a table in multiple files. the basic unit oracle uses is
a block which is a multiple of the os block. a contiguous set of blocks = an extent and a table can have many extents spread over many datafiles.

HTH
regards
brian

Dave <none_at_nowhere.nothere.oops> wrote in message news:7vpe61$bj6$1_at_lure.pipex.net...
> 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
>
>
>
Received on Wed Nov 03 1999 - 10:53:01 CST