Re: p1 p2 - is it a header block?

The "first" header block will have the lowest block number for that segment. When I say "first" I mean that in 7.3 (because of unlimited maxextents) they created a new type of "overflow" blocks that might in extreme cases also show up as the first blocks - I'm not sure, but Anjo or someone probably knows?

Mogens

(back on the list after mysteriousely being thrown out some time ago?).

Greg Moore wrote:

>If you have the file number and block number, you can find which segment it
>is. (You find the block belongs to the EMP table.)
>
>Is there a way to tell if that block is the header block of the segment?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?=
  INET: mln_at_miracleas.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).