Segments
Segments are space-occupying objects in the database's data files. This means that they are associated with things that take up space, such as tables, indexes, clusters, and other similar objects.
Table Segments
Tables are the most common means of storing data within a database. A table's segment stores the data for a table that is neither a cluster table nor a partitioned table. Data within the segment is stored in no particular order, a situation that the database administrator (DBA) has little control over. DBAs can't control the location of rows within the blocks within the segments in the table. All the data within a table segment must be stored within a single tablespace.
Table Partition Segment
Because scalability, maintainability, ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
