SEGMENT MAXEXTENT NOTES:

Owner - Owner of the segment

Segment Type - Type of segment

Max Extents - MaxExtents value

Count - Number of records with this MaxExtents value

Your maxextents are dependent on your blocksize and version of Oracle you're running:

• 1K DB_BLOCKSIZE = 57 extents
• 2K DB_BLOCKSIZE = 121 extents
• 4K DB_BLOCKSIZE = 249 extents
• 8K DB_BLOCKSIZE = 505 extents
• 16K DB_BLOCKSIZE = 1017 extents

You can use (DBBLOCKSIZE / 16 -7) to determine the correct MAXEXTENTS for your blocksize

As of Oracle v7.3 you can specify MAXEXTENTS UNLIMITED (actually 2,147,483,645 extents)