Third level of logical database storage. A segment is a set of extents, each of which has been allocated for a specific data structure, and all of which are stored in the same tablespace. See Also: extent, data block

a collection of extents that have been allocated for a specific object

a convenient block of logical memory which is assigned to a process when it is executed

a logical data object that stores the data of a table, index, or series of rollback entries

a set of extents allocated for a certain logical database object

a set of extents allocated for a certain logical structure

a set of extents that contain all the data for a specific logical storage structure within a tablespace

a set of extents that have been allocated for a specific type of data structure, and that all are stored in the same tablespace

a unit of logical database storage

The set of extents that have been allocated to a specific object. Segment types consist of data, index, cluster, hash, and rollback.

A set of extents allocated for a specific type of database object such as a table, index, or cluster.

A segment is a set of database blocks allocated for storage of database data. Although there are several types of segments, all have a similar structure and are made up of extents. Most segments begin with a specified number of extents and grow dynamically by adding extents when required.

Any database object that has space allocated to it is called a SEGMENT segment consists of one or more EXTENTS allocated within a tablespace. See catalog views: USER_SEGMENTS and DBA_SEGMENTS. Note there is no ALL_SEGMENTS view.