Author: DJMURRAY Subject: Max Extents of 121 - Some Clarification Modified: 11 Sep 94 There seems to be some confusion as to what is the maximum number of extents an object can have. Some people seem to think this is port specific. IT IS ***NOT*** PORT SPECIFIC The maximum number of extents an object can have is governed by the blocksize of the database, as follows: Database Maximum Blocksize # extents --------- --------- 1k 57 2k 121 4k 249 etc... So for example a database with 4k blocksize on a UNIX box has a maximum number of extents of 249 not 121. The reason for this is that the extent map is stored in the segment header (ie first block of the object). So the bigger the header block (database blocksize) the more extents it can map.