The following table lists the statuses that a segment can have.
Table 14-3 Segment statuses
Segment status | Explanation |
---|---|
Used segment# | This is a segment that stores table or index data. A segment that is full, such that no more data can be added, is called a full segment. A segment from which all the data has been deleted, such that all pages are free pages (used free pages or unused pages), is called a used free segment. |
Unused segment | This is a segment that has never been used. Such a segment can be used by all tables (or indexes) in the RDAREA. |
Free segment | This is a segment that does not store any data. Used free segments and unused segments are free segments. |