What is a Data Segment ?
Answers were Sorted based on User's Feedback
Answer / narendra
Data Segment is a collection of extents used to store the data of a table and the table can be a non-clustered table, a clustered table, or a partitioned table, so we can also call Data Segment as Table Segment.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / nishi
Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / orawhiz
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.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is a procedure in oracle?
when do u go for hash partitioning?
What are various constraints used in SQL?
What is a table index?
What is the difference between alert log file and trace file ?
What is the use of Control File ?
Can objects of the same schema reside in different tablespace?
How to define an anonymous block?
What is RULE-based approach to optimization ?
What is a sub query? Describe its types?
What is a Synonym ?
What is the quickest way to fetch the data from a table?