Re: Can a segment span more than one datafiles

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Thu, 15 May 2003 09:21:46 +0200
Message-ID: <b9vf32$98o$1@news.mch.sbs.de>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:cff6cvkedqaugm85sugg6mag2v47dv08rv_at_4ax.com...
> 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?
Hi,
a segment can own extents in one, some or all datafiles of the tbs it belongs to.
An extent is always located one and only one datafile. How could a single block span datafiles? It's the smallest storage unit!.

Regards
Stephan Received on Thu May 15 2003 - 02:21:46 CDT