Re: what is concept of table in Oracle
From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 16 Sep 2008 06:28:16 -0700
Message-ID: <1221571696.475153@bubbleator.drizzle.com>
>
> Indeed. A table is made up of segments which, in turn, are made up of
> extents.
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro.htm#sthref63
>
> HTH
>
> -g
Date: Tue, 16 Sep 2008 06:28:16 -0700
Message-ID: <1221571696.475153@bubbleator.drizzle.com>
gazzag wrote:
> On 16 Sep, 09:29, fatshaw <fats..._at_gmail.com> 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.
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro.htm#sthref63
>
> HTH
>
> -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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Sep 16 2008 - 08:28:16 CDT