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.