What is a Data Segment ?

Each Non-clustered table has a data segment. All of the table's data is stored in the extents of its data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster's data segment.

Interview Candidate
Sep 5th, 2004
4
3620

Concepts and Architecture

Answer

Showing Answers 1 - 4 of 4 Answers

taraldesai
Profile Answers by taraldesai

Jan 28th, 2008

it's you table, index and else

GUEST

May 8th, 2013

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.

pradeep

May 5th, 2015

A data segment is a set of extents allocated to a certain logical structures

Harshad Khuspe

Dec 27th, 2015

Tablespace is made up of Segment. Segment is made up of extents and extents are made up of contiguous oracle blocks. Segments are nothing but a table. i.e. Table Emp is nothing but segment emp. You can check things from data dictionary view DBA_Segments.