A
segment is a set of extents that contains all the data for a specific logical storage structure within a tablespace. For example, for each table,
Oracle allocates one or more extents to form that table's data
segment, and for each index,
Oracle allocates one or more extents to form its index
segment.
read more >>