Re: Tablespace usage question....................................................................................................................................

The answer to the question you asked is yes.

Explaination:
All extents for a segment belong to one and only one tablespace. One extent of a particular segment can only be in one datafile. Another extent could be on a different datafile which may or may not be on the same disk.

Hope this helps,

Manoj Jain
DBA In article <6fo9ro$hj9$1_at_newsread1-mx.centuryinter.net>,   austby_at_centuryinter.net (A Ustby) wrote:
>
>
> The question I have deals with table space allocations within a tablespace.
>
> Lets say I have a tablespace allocated with 3 datafiles of 100M each (total
> of 300 M). I have found that if I have a table whose primary allocation is
> 120M, I'll have problems because the primary size is greater than one of the
> datafiles. So I have determined that the primary space must be held within
> a single datafile.
>
> My main question is, for a given table, that goes into multiple
> extents, can those extents be in different datafiles within the tablespace ?
>
>

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