Re: Can a segment span more than one datafiles

Peter wrote:
>
> A tablespace can span more than one datafiles, but can a segment span
> more than one datafiles? I am just wondering what is the smallest
> Oracle unit that can span different datafiles.
> How about data block spanning datafiles? How about an extent?

In order by composition you have:

data blocks
which add up to extents
which add up to segments

Since a single extent exists within a single datafile we can conclude that blocks can't span a file, segments can.

tablespaces are not really related, in that they are just a logical grouping of datafiles

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"