Concepts and Architecture Interview Question:

What is a Data Segment in Oracle?

Submitted by: Administrator

The level of logical database storage above an extent is called a segment. 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. For example, each tables data is stored in its own data segment, while each index data is stored in its own index segment. If the table or index is partitioned, each partition is stored in its own segment.
Submitted by: Administrator