Re: what is concept of table in Oracle

From: DA Morgan <>
Date: Tue, 16 Sep 2008 06:28:16 -0700
Message-ID: <>

gazzag wrote:
> On 16 Sep, 09:29, fatshaw <> wrote:

>> i want to know what is concept of table in Oracle?is there any
>> relations to segment?

> Indeed. A table is made up of segments which, in turn, are made up of
> extents.
> -g

Correction. A segment is made up of extents which are made up of blocks. The only table types made up of segments are partitioned and IOT. A heap table is always a single segment.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Sep 16 2008 - 08:28:16 CDT

Original text of this message