Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large files under oracle7.1.6
A table can span datafiles, but a single extent cannot. To great a table
that requires 28GB, create a tablespace with enough 2GB datafiles for the
data, free space, etc. Create the table with an initial extent that will
fit into 2GB, and a next extent the will use the next 2GB. You just end up
with a table that has multiple extents.
johnny_chan_at_earthling.net wrote in message
<6d1ucv$p9k$1_at_nnrp1.dejanews.com>...
>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.
>>
>
>the above statement is not correct. you can easily have a table span
multiple
>datafiles, as long as the datafiles are all part of the same tablespace.
you
>are confusing the correct restriction that a table cannot span multiple
>tablespaces.
>
>Johnny Chan
>Independent Oracle Specialist
>
>> 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 Thu Feb 26 1998 - 00:00:00 CST